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

DB2 CAN CRASH ON SQLE_ADD_SETINFO AFTER SQLO_NOMEM_MONH ERRORS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 can crash with the following errors in the db2diag.log 
 
009-06-17-02.56.47.405150+060 I970013A580        LEVEL: Severe 
PID     : 11659                TID  : 11989       PROC : db2sysc 
0 
INSTANCE: peulb012             NODE : 000         DB   : 
PEEUCLSP 
APPHDL  : 0-40877              APPID: GA606649.NE06.010D47015455 
AUTHID  : XLOSPD01 
EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP) 0 
FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo_field, 
probe:20 
RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH 
          "No memory available in 'Database Monitor Heap'" 
          DIA8300C A memory heap error has occurred. 
 
 
2009-06-17-02.56.47.410539+060 I982166A574        LEVEL: Severe 
PID     : 11659                TID  : 11989       PROC : db2sysc 
0 
INSTANCE: peulb012             NODE : 000         DB   : 
PEEUCLSP 
APPHDL  : 0-40877              APPID: GA606649.NE06.010D47015455 
AUTHID  : XLOSPD01 
EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP) 0 
FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo, 
probe:25 
RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH 
          "No memory available in 'Database Monitor Heap'" 
          DIA8300C A memory heap error has occurred. 
 
 
2009-06-17-02.57.40.751824+060 I5509953A565       LEVEL: Error 
PID     : 11659                TID  : 11989       PROC : db2sysc 
0 
INSTANCE: peulb012             NODE : 000         DB   : 
PEEUCLSP 
APPHDL  : 0-40877              APPID: GA606649.NE06.010D47015455 
AUTHID  : XLOSPD01 
EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP) 0 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:1 
MESSAGE : Error in agent servicing application with coor_node: 
DATA #1 : Hexdump, 2 bytes 
0xFFFFFFFA330096C4 : 0000 
 
The trap file will show the following functions on top of the 
stack (sqle_add_setinfo) 
 
 
<StackTrace> 
##### Object: /platform/sun4u-us3/lib/sparcv9/libc_psr.so.1 
_memcmp(0x180,0xfffffffc428eec75,0x0,0xffffffff7ed0fe68,0xffffff 
ff7e5aa5a8,0x204860780) + 0x38 
##### Object: /local/0/opt/IBM/db2/V9.5.FP2/lib64/libdb2e.so.1 
__1cQsqle_add_setinfo6FIpcI_i_(0x180,0xfffffffc428eec75,0x0,0xff 
ffffff7ed0fe68,0xffffffff7e5aa5a8,0x204860780) + 0x47c 
__1cUsqlnq_set_clientinfo6FppnIstknode__inKactiontype_pCpnDloc__ 
i_(0xffffffff581d9e78,0xfffffffc428eec74,0x180,0x0,0xffffffff7ed 
0fe68,0x30) + 0x380 
__1cMsqlnp_smactn6FpnIsqlnp_cb_i_i_(0xfffffffc428e03e0,0xca3c,0x 
fffffffc428e0518,0x19c80004,0x19c80000,0xffffffff7e5aa5a8
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 CAN CRASH ON SQLE_ADD_SETINFO AFTER SQLO_NOMEM_MONH      * 
* ERRORS                                                       * 
* DB2 can crash with the following errors in the db2diag.log   * 
*                                                              * 
*                                                              * 
*                                                              * 
* 009-06-17-02.56.47.405150+060 I970013A580        LEVEL:      * 
* Severe                                                       * 
* PID     : 11659                TID  : 11989       PROC :     * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: peulb012             NODE : 000         DB   :     * 
*                                                              * 
* PEEUCLSP                                                     * 
*                                                              * 
* APPHDL  : 0-40877              APPID:                        * 
* GA606649.NE06.010D47015455                                   * 
* AUTHID  : XLOSPD01                                           * 
*                                                              * 
* EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP)  * 
* 0                                                            * 
* FUNCTION: DB2 UDB, base sys utilities,                       * 
* sqle_add_setinfo_field,                                      * 
* probe:20                                                     * 
*                                                              * 
* RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH         * 
*                                                              * 
* "No memory available in 'Database Monitor Heap'"             * 
*                                                              * 
* DIA8300C A memory heap error has occurred.                   * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-06-17-02.56.47.410539+060 I982166A574        LEVEL:     * 
* Severe                                                       * 
* PID     : 11659                TID  : 11989       PROC :     * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: peulb012             NODE : 000         DB   :     * 
*                                                              * 
* PEEUCLSP                                                     * 
*                                                              * 
* APPHDL  : 0-40877              APPID:                        * 
* GA606649.NE06.010D47015455                                   * 
* AUTHID  : XLOSPD01                                           * 
*                                                              * 
* EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP)  * 
* 0                                                            * 
* FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo,     * 
*                                                              * 
* probe:25                                                     * 
*                                                              * 
* RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH         * 
*                                                              * 
* "No memory available in 'Database Monitor Heap'"             * 
*                                                              * 
* DIA8300C A memory heap error has occurred.                   * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-06-17-02.57.40.751824+060 I5509953A565       LEVEL:     * 
* Error                                                        * 
* PID     : 11659                TID  : 11989       PROC :     * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: peulb012             NODE : 000         DB   :     * 
*                                                              * 
* PEEUCLSP                                                     * 
*                                                              * 
* APPHDL  : 0-40877              APPID:                        * 
* GA606649.NE06.010D47015455                                   * 
* AUTHID  : XLOSPD01                                           * 
*                                                              * 
* EDUID   : 11989                EDUNAME: db2agent (PEEUCLSP)  * 
* 0                                                            * 
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,    * 
*                                                              * 
* probe:1                                                      * 
*                                                              * 
* MESSAGE : Error in agent servicing application with          * 
* coor_node:                                                   * 
* DATA #1 : Hexdump, 2 bytes                                   * 
*                                                              * 
* 0xFFFFFFFA330096C4 : 0000                                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* The trap file will show the following functions on top of    * 
* the                                                          * 
* stack (sqle_add_setinfo)                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* <StackTrace>                                                 * 
*                                                              * 
* ##### Object: /platform/sun4u-us3/lib/sparcv9/libc_psr.so.1  * 
*                                                              * 
* _memcmp(0x180,0xfffffffc428eec75,0x0,0xffffffff7ed0fe68,0xffff 
* ff7e5aa5a8,0x204860780) + 0x38                               * 
*                                                              * 
* ##### Object:                                                * 
* /local/0/opt/IBM/db2/V9.5.FP2/lib64/libdb2e.so.1             * 
* __1cQsqle_add_setinfo6FIpcI_i_(0x180,0xfffffffc428eec75,0x0,0x 
* ffffff7ed0fe68,0xffffffff7e5aa5a8,0x204860780) + 0x47c       * 
*                                                              * 
* __1cUsqlnq_set_clientinfo6FppnIstknode__inKactiontype_pCpnDloc 
* i_(0xffffffff581d9e78,0xfffffffc428eec74,0x180,0x0,0xffffffff7 
* 0fe68,0x30) + 0x380                                          * 
*                                                              * 
* __1cMsqlnp_smactn6FpnIsqlnp_cb_i_i_(0xfffffffc428e03e0,0xca3c, 
* fffffffc428e0518,0x19c80004,0x19c80000,0xffffffff7e5aa5a8    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7FP1                                       * 
****************************************************************
Local-Fix:
Increase MON_HEAP_SZ or set it to AUTOMATIC.
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 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.06.2009
15.12.2009
15.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList