DB2 - Problem description
Problem IC74639 | Status: Closed |
INSTANCE ABENDS IN SQLBTERMINATEAPPLICATION WHEN DATABASE HEAP IS TOO SMALL | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
When Database Heap is too small to allow for an application to initialize properly, the instance may abend during the application cleanup phase in sqlbTerminateApplication(). db2diag.log: ============ 2011-02-14-02.07.24.853687-300 I1182759E571 LEVEL: Severe PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database monitor, sqlmon_bpcb::init_bpcb, probe:30 RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH "No memory available in 'Database Heap'" DIA8302C No memory available in the database heap. 2011-02-14-02.07.24.853835-300 E1183331E570 LEVEL: Error PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, data protection services, sqlpInitAgent, probe:400 MESSAGE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH "No memory available in 'Database Heap'" DIA8302C No memory available in the database heap. 2011-02-14-02.07.24.855214-300 I1183902E569 LEVEL: Severe PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AssocApp, probe:30 RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH "No memory available in 'Database Heap'" DIA8302C No memory available in the database heap. 2011-02-14-02.07.24.855335-300 I1184472E449 LEVEL: Warning PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (idle) 0 FUNCTION: DB2 UDB, base sys utilities, sqlePdbRemap, probe:100 MESSAGE : ZRC 8b0f0002 remapped to SQLCODE -956 2011-02-14-02.07.24.856439-300 I1184922E447 LEVEL: Severe PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (idle) 0 FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140 RETCODE : ZRC=0xFFFFFC44=-956 2011-02-14-02.07.25.050871-300 I1190869E502 LEVEL: Warning PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (idle) 0 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 DATA #1 : String, 29 bytes _Z24sqlbTerminateApplication DATA #2 : String, 4 bytes sqlb 2011-02-14-02.07.25.229995-300 I1191372E561 LEVEL: Severe PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (idle) 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x0000000400003801 DATA #3 : Boolean, 1 bytes false 2011-02-14-02.07.25.230168-300 I1191934E559 LEVEL: Error PID : 3944 TID : 46929744488768PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-5160 APPID: *N0.db2inst1.110214082256 AUTHID : DB2INST1 EDUID : 763 EDUNAME: db2agent (idle) 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 0x00002AAEAE80F592 : 0000 .. Trap File: ========== Signal #11 (SIGSEGV): si_addr is 0x0000000000000020, si_code is 0x00000001 (SEGV_MAPERR:Address not mapped to object.) sqlbTerminateApplication sqeApplication::HandleStartUsingError sqeApplication::AppStartUsing sqeApplication::AppSecondaryStartUsing sqeApplication::AppLocalStart sqlelostWrp sqleUCengnInit sqleUCagentConnect sqljsConnectAttach | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * See APAR description. * **************************************************************** * PROBLEM DESCRIPTION: * * See APAR description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 UDB 9.7 FixPak 4 * **************************************************************** | |
Local Fix: | |
Increase the size of Database Heap. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Problem first fixed in DB2 UDB 9.7 FixPak 4 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2011 28.04.2011 28.04.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |