|
Problem IC61499
|
Status: Closed |
DB2 CAN CRASH ON SQLE_ADD_SETINFO AFTER SQLO_NOMEM_MONH ERRORS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.06.2009
15.12.2009
15.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
