|
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
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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) |
