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 |
|