| Neueste Versionen | 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 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC99705 | Status: Geschlossen |
SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCE OWNER. | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
| verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Lösung | |
First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.02.2014 13.10.2014 13.10.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.5.0.4 |
|