DB2 - Problembeschreibung
Problem IC64053 | Status: Geschlossen |
USING 'SHOW OBJECTS DETAILS PANEL' IN CONTROL CENTER USING A NON-ADMIN USERID RESULTS IN SQL1092N FOR SYSPROC.GET_DBINFO_SIZE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When using the 'Show Objects Details Panel' in control Center when connected using a non-admin userid there is a call to SYSPROC.GET_DBINFO_SIZE which results with a sql1092n error. Since the control center panel is refreshed every 5 minutes you see many of these errors in the db2diag.log file. In the db2diag.log file you will see: 2009-06-17-15.21.53.046000-300 E69388H598 LEVEL: Warning PID : 3368 TID : 852 PROC : db2fmp.exe INSTANCE: DB2 NODE : 000 EDUID : 852 FUNCTION: DB2 UDB, routine_infrastructure, sqlerFencedTruncateTokensUserSqlState, probe:100 DATA #1 : signed integer, 4 bytes -443 DATA #2 : String with size, 5 bytes 38553 DATA #3 : String with size, 23 bytes SYSPROC.GET_DBSIZE_INFO DATA #4 : String with size, 15 bytes GET_DBSIZE_INFO DATA #5 : String with size, 69 bytes SQL1092 Reason code or token: DB2USER sqlerFmpRunProc.C | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * NON-ADMIN USERS OF THE CONTROL CENTER * **************************************************************** * PROBLEM DESCRIPTION: * * When using the 'Show Objects Details Panel' in Control * * Center when connected to a database using a non-admin * * userid, the call to * * SYSPROC.GET_DBINFO_SIZE fails with a sql1092n error. * * * * SQL1092N "<authorization-ID>" does not have the authority * * to perform * * the requested command. * **************************************************************** * RECOMMENDATION: * * Don't use the 'Show Objects Details Panel' if not necessary. * * or * * Use and Administrator ID when needed. * * or * * Upgrade to V9.7 Fixpak 1. * **************************************************************** | |
Local-Fix: | |
Don't use the 'Show Objects Details Panel' if not necessary. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fixpak 1. | |
Workaround | |
Use an Admin ID to use the Control Center function. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.10.2009 06.01.2010 06.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |