home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList