DB2 - Problem description
Problem IT19853 | Status: Closed |
SIGNAL 11 TRAP AT SQLRA_GET_VAR | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When some memory constraints happened on the system, one may see SQLO_NOMEM_APPSHRH errors from the sqlra_load_var function in the db2diag.log, followed by a trap immediately following in sqlra_get_var() with signal 11. Sample db2diag.log reported by the trapping EDU: 2017-02-24-15.04.24.490958+000 I59687656E679 LEVEL: Error PID : 13912 TID : 140699005609728 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : BLUDB APPHDL : 0-306 APPID: *LOCAL.db2inst1.170224143310 AUTHID : DB2INST1 HOSTNAME: hostname.net EDUID : 104 EDUNAME: db2agent (BLUDB) 0 FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_get_dynamic_section, probe:900 RETCODE : ZRC=0x8B0F0014=-1961951212=SQLO_NOMEM_APPSHRH "No memory available in 'Applications Shared Heap'" DIA8300C A memory heap error has occurred. 2017-02-24-15.04.24.491694+000 I59688336E1100 LEVEL: Error PID : 13912 TID : 140699005609728 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : BLUDB APPHDL : 0-306 APPID: *LOCAL.db2inst1.170224143310 AUTHID : DB2INST1 HOSTNAME: hostname.net EDUID : 104 EDUNAME: db2agent (BLUDB) 0 FUNCTION: DB2 UDB, access plan manager, sqlra_load_var, probe:200 MESSAGE : ZRC=0x8B0F0014=-1961951212=SQLO_NOMEM_APPSHRH "No memory available in 'Applications Shared Heap'" DIA8300C A memory heap error has occurred. DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -973 sqlerrml: 18 sqlerrmc: application shared sqlerrp : SQLRA115 sqlerrd : (1) 0x8B0F0014 (2) 0x00000014 (3) 0x00000000 (4) 0x0000002A (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: stack of the trap would look like 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 _IO_ftrylockfile 6 sqlra_get_var 7 sqlrr_prepare 8 sqljs_ddm_prpsqlstt 9 sqljsParseRdbAccessed 10 sqljsParse 11 sqljsSqlam 12 sqljsDrdaAsInnerDriver 13 sqljsDrdaAsDriver 14 sqeAgent::RunEDU 15 sqzEDUObj::EDUDriver 16 sqloEDUEntry 17 start_thread 18 clone | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.03.2017 27.06.2017 27.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |