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







 
