DB2 - Problembeschreibung
Problem IC74639 | Status: Geschlossen |
INSTANCE ABENDS IN SQLBTERMINATEAPPLICATION WHEN DATABASE HEAP IS TOO SMALL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 UDB 9.7 FixPak 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.02.2011 28.04.2011 28.04.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |