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 IC74412 Status: Geschlossen

DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION ABNORMALLY TERMINATES

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION ABNORMALLY 
TERMINATES 
 
In db2diag.log: 
2011-02-01-08.00.02.629349+660 I6110387A653       LEVEL: Warning 
PID     : 839690               TID  : 131975      PROC : db2sysc 
0 
INSTANCE: name01               NODE : 000         DB   : 
name0101 
APPHDL  : 0-6948               APPID: *N0.name01.110204103154 
AUTHID  : P08093 
EDUID   : 131975               EDUNAME: db2agent (name0101) 0 
FUNCTION: DB2 UDB, oper system services, 
sqloInvokeInterruptible, probe:20 
DATA #1 : String, 208 bytes 
An unfenced User Defined Function (UDF) was abnormally 
terminated. 
This may leave the DB2 engine in inconsistent state. 
It is recommended that DB2 server instance is stopped and 
restarted as soon as possible. 
 
2011-02-01-08.00.02.630932+660 I6111041A1212      LEVEL: Error 
PID     : 839690               TID  : 131975      PROC : db2sysc 
0 
INSTANCE: name01               NODE : 000         DB   : 
name0101 
APPHDL  : 0-6948               APPID: *N0.name01.110204103154 
AUTHID  : P08093 
EDUID   : 131975               EDUNAME: db2agent (name0101) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : Reporting -1476; old SQLCA: 
DATA #1 : Hexdump, 136 bytes 
0x07800000018F3BE8 : 5351 4C43 4120 2020 0000 0088 FFFF FE52 
SQLCA   .......R 
0x07800000018F3BF8 : 0020 5359 5346 554E 2E55 5345 5253 5F47 
. SYSFUN.USERS_G 
0x07800000018F3C08 : 524F 5550 53FF 5553 4552 535F 4752 4F55 
ROUPS.USERS_GROU 
0x07800000018F3C18 : 5053 2020 2020 2020 2020 2020 2020 2020 
PS 
...... 
 
There are two thread stacks, the first is: 
 
<StackTrace> 
strcmp 
sqloLookupGroupInfoForUser 
sqlolgr3 
getListofUsersAndGroups 
sqloInvokeFnArgs 
sqloInvokeUDF 
sqloInvokeUDF 
sqlriInvokerTrusted 
sqlriInvokeInvoker 
sqlriutf__FP8sqlrr_cb 
sqlri_tfopn 
sqlriopn 
sqlriopn 
sqlrita 
sqlriopn 
sqlrita 
sqlriNljnPiped 
sqlriSectInvoke 
sqlrr_process_fetch_request 
sqlrr_open 
sqljs_ddm_opnqry 
sqljsParseRdbAccessed 
sqljsParse 
sqljsSqlam 
sqljsDriveRequests 
sqljsDrdaAsInnerDriver 
sqljsDrdaAsDriver 
RunEDU 
EDUDriver 
sqlzRunEDU 
sqloEDUEntry 
</StackTrace> 
 
The second is: 
<StackTrace> 
sqloCrashOnCriticalMemoryValidationFailure 
sqloCrashOnCriticalMemoryValidationFailure 
sqlofmblkEx 
sqlerCallDL 
sqljs_ddm_excsqlstt 
sqljsParseRdbAccessed 
sqljsParse 
sqljsSqlam 
sqljsDriveRequests 
sqljsDrdaAsInnerDriver 
sqljsDrdaAsDriver 
RunEDU 
EDUDriver 
sqlzRunEDU 
EDUDriver 
sqlzRunEDU 
sqloEDUEntry 
</StackTrace> 
 
Local Fix: 
The groupsforuser function SYSFUN.USERS_GROUPS has been 
deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID table 
function is recommended to use instead.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION           * 
* ABNORMALLY TERMINATES                                        * 
*                                                              * 
* In db2diag.log:                                              * 
* 2011-02-01-08.00.02.629349+660 I6110387A653      LEVEL:      * 
* Warning                                                      * 
* PID    : 839690              TID  : 131975      PROC :       * 
* db2sysc 0                                                    * 
* INSTANCE: dwaprd              NODE : 000        DB  :        * 
* DWAPRD01                                                     * 
* APPHDL  : 0-6948              APPID: *N0.dwaprd.110204103154 * 
* AUTHID  : P08093                                             * 
* EDUID  : 131975              EDUNAME: db2agent (DWAPRD01) 0  * 
* FUNCTION: DB2 UDB, oper system services,                     * 
* sqloInvokeInterruptible, probe:20                            * 
* DATA #1 : String, 208 bytes                                  * 
* An unfenced User Defined Function (UDF) was abnormally       * 
* terminated.                                                  * 
* This may leave the DB2 engine in inconsistent state.         * 
* It is recommended that DB2 server instance is stopped and    * 
* restarted as soon as possible.                               * 
*                                                              * 
* 2011-02-01-08.00.02.630932+660 I6111041A1212      LEVEL:     * 
* Error                                                        * 
* PID    : 839690              TID  : 131975      PROC :       * 
* db2sysc 0                                                    * 
* INSTANCE: dwaprd              NODE : 000        DB  :        * 
* DWAPRD01                                                     * 
* APPHDL  : 0-6948              APPID: *N0.dwaprd.110204103154 * 
* AUTHID  : P08093                                             * 
* EDUID  : 131975              EDUNAME: db2agent (DWAPRD01) 0  * 
* FUNCTION: DB2 UDB, trace services, sqlt_logerr_data          * 
* (secondary logging func, probe:0                             * 
* MESSAGE : Reporting -1476; old SQLCA:                        * 
* DATA #1 : Hexdump, 136 bytes                                 * 
* 0x07800000018F3BE8 : 5351 4C43 4120 2020 0000 0088 FFFF FE52 * 
* SQLCA  .......R                                              * 
* 0x07800000018F3BF8 : 0020 5359 5346 554E 2E55 5345 5253 5F47 * 
* . SYSFUN.USERS_G                                             * 
* 0x07800000018F3C08 : 524F 5550 53FF 5553 4552 535F 4752 4F55 * 
* ROUPS.USERS_GROU                                             * 
* 0x07800000018F3C18 : 5053 2020 2020 2020 2020 2020 2020 2020 * 
* PS                                                           * 
* ......                                                       * 
*                                                              * 
* There is 2 thread stack, the first is:                       * 
* <StackTrace>                                                 * 
*                                                              * 
* -------Frame------ ------Function + Offset------             * 
*                                                              * 
* 0x0900000001BF50E8 strcmp + 0x4                              * 
*                                                              * 
* 0x09000000015228A4                                           * 
*                                                              * 
* @71@sqloLookupGroupInfoForUser__FCP11SQLO_USERPWCP13sqlo_ubi_d 
* +                                                            * 
* 0x8A0                                                        * 
* \u0007P                                                      * 
* 0x0900000001521F1C sqlolgr3 + 0x228                          * 
*                                                              * 
* 0x0900000012590ACC getListofUsersAndGroups + 0x26C           * 
*                                                              * 
* 0x090000000D84FA0C sqloInvokeFnArgs + 0xC0                   * 
*                                                              * 
* 0x090000000FD154E0 sqloInvokeUDF + 0x220                     * 
*                                                              * 
* 0x090000000FD15214 sqloInvokeUDF@glue50E + 0x7C              * 
*                                                              * 
* 0x090000000D9AC8CC                                           * 
*                                                              * 
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf  * 
* + 0x1024                                                     * 
* 0x090000000DB03A38 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 * 
*                                                              * 
* 0x090000000EB67D98 sqlriutf__FP8sqlrr_cb + 0x130             * 
*                                                              * 
* 0x090000000E61E0AC sqlri_tfopn__FP8sqlrr_cbP9sqlri_tao +     * 
* 0x1D4                                                        * 
* 0x090000000D667D90 sqlriopn__FP8sqlrr_cbP9sqlri_taoPi +      * 
* 0x7C0                                                        * 
* 0x090000000D7DADD0                                           * 
* sqlriopn__FP8sqlrr_cbP9sqlri_taoPi@glue1D1 + 0x70            * 
* 0x090000000D79D1E8 sqlrita__FP8sqlrr_cb + 0xC                * 
*                                                              * 
* 0x090000000D7DADD0                                           * 
* sqlriopn__FP8sqlrr_cbP9sqlri_taoPi@glue1D1 + 0x70            * 
* 0x090000000D79D1E8 sqlrita__FP8sqlrr_cb + 0xC                * 
*                                                              * 
* 0x090000000D7FED08 sqlriNljnPiped__FP8sqlrr_cb - 0x7C        * 
* \u0007P                                                      * 
* 0x090000000D801BE0                                           * 
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x7A8          * 
* 0x090000000D836A24                                           * 
* sqlrr_process_fetch_request__FP14db2UCinterface +            * 
* 0x150                                                        * 
*                                                              * 
* 0x090000000D82F7D0                                           * 
* sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo +           * 
* 0x518                                                        * 
*                                                              * 
* 0x090000000D985C28                                           * 
* sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject         * 
* + 0x95C                                                      * 
*                                                              * 
* 0x090000000D9851C4                                           * 
*                                                              * 
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2 
*                                                              * 
* e + 0x4                                                      * 
*                                                              * 
* 0x090000000D841DA0                                           * 
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface -             * 
* 0x124                                                        * 
*                                                              * 
* 0x090000000D84336C                                           * 
* @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x168        * 
* 0x090000000D93D228                                           * 
* @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle         * 
* + 0x98                                                       * 
*                                                              * 
* 0x090000000D93D090                                           * 
* @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb +        * 
* \u0007P                                                      * 
* 0xE4                                                         * 
*                                                              * 
* 0x090000000D93CDE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * 
* + 0xD8                                                       * 
* 0x090000000D895498 RunEDU__8sqeAgentFv + 0x11C               * 
*                                                              * 
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94            * 
*                                                              * 
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC                   * 
*                                                              * 
* 0x090000000D89C6F0 sqloEDUEntry + 0x57C                      * 
*                                                              * 
* </StackTrace>                                                * 
*                                                              * 
*                                                              * 
* The second is:                                               * 
* <StackTrace>                                                 * 
*                                                              * 
* -------Frame------ ------Function + Offset------             * 
*                                                              * 
* 0x090000000F88BA58                                           * 
* sqloCrashOnCriticalMemoryValidationFailure + 0x30            * 
* 0x090000000F88CC44                                           * 
* sqloCrashOnCriticalMemoryValidationFailure@glue5F7 +         * 
* \u0007P                                                      * 
* 0x74                                                         * 
*                                                              * 
* 0x090000000DE522D4 sqlofmblkEx + 0x38                        * 
*                                                              * 
* 0x090000000D97A26C                                           * 
* sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x6DC           * 
* 0x090000000D97A510                                           * 
*                                                              * 
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject +    * 
* 0xA8                                                         * 
* 0x090000000D841F8C                                           * 
*                                                              * 
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2 
*                                                              * 
* e + 0x78                                                     * 
*                                                              * 
* 0x090000000D841DA0                                           * 
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface -             * 
* 0x124                                                        * 
*                                                              * 
* 0x090000000D84336C                                           * 
* @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x168        * 
* 0x090000000D93D228                                           * 
* @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle         * 
* + 0x98                                                       * 
*                                                              * 
* 0x090000000D93D090                                           * 
* @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb +        * 
* 0xE4                                                         * 
*                                                              * 
* 0x090000000D93CDE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * 
* + 0xD8      \u0007P                                          * 
* 0x090000000D895498 RunEDU__8sqeAgentFv + 0x11C               * 
*                                                              * 
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94            * 
*                                                              * 
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC                   * 
*                                                              * 
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94            * 
*                                                              * 
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC                   * 
*                                                              * 
* 0x090000000D89C6F0 sqloEDUEntry + 0x57C                      * 
*                                                              * 
* </StackTrace>                                                * 
*                                                              * 
* Local Fix:                                                   * 
* The groupsforuser function SYSFUN.USERS_GROUPS has been      * 
* deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID      * 
* table function is recommended to use instead.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrde to DB2 version 9.5fp8                                 * 
****************************************************************
Local-Fix:
The groupsforuser function SYSFUN.USERS_GROUPS has been 
deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID table 
function is recommended to use instead.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 UDB Version 9.5fp8
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.02.2011
17.08.2011
17.08.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList