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 | |
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 |