| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC99705 | Status: Closed |
SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCE OWNER. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Some system functions that get created automatically by DB2, incorrectly have the instance userid set as the owner of these functions. It would be more appropriate to have SYSIBM as the owner. Other than this owner field, there is no impact of this owner as the instance user cannot modify the functions anyway. ( results in error ) To see which functions are affected, run : db2 "select substr(owner,1,10) owner, substr(routinename,1,20) routinename , substr(ROUTINESCHEMA,1,10) ROUTINESCHEMA ,ownertype,routinetype from syscat.routines where ROUTINESCHEMA = 'SYSPROC' and owner <> 'SYSIBM' " ; OWNER ROUTINENAME ROUTINESCHEMA OWNERTYPE ROUTINETYPE ---------- -------------------- ------------- --------- ----------- DB2INST3 DB2SECURITYLABEL SYSPROC U F DB2INST3 VARCHAR SYSPROC U F DB2INST3 = SYSPROC U F DB2INST3 < SYSPROC U F DB2INST3 > SYSPROC U F DB2INST3 <= SYSPROC U F DB2INST3 >= SYSPROC U F DB2INST3 <> SYSPROC U F DB2INST3 DB2SQLSTATE SYSPROC U F DB2INST3 CHAR SYSPROC U F DB2INST3 DB2SQLSTATE SYSPROC U F DB2INST3 = SYSPROC U F DB2INST3 < SYSPROC U F DB2INST3 > SYSPROC U F DB2INST3 <= SYSPROC U F DB2INST3 >= SYSPROC U F DB2INST3 <> SYSPROC U F 17 record(s) selected. The fix for this apar will correct this for new databases. For existing databases the ownership of these functions will remain the same. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix * * Pack 4) or Later * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Solution | |
First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.02.2014 13.10.2014 13.10.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.4 |
|