home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList