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 IT06532 Status: Closed

DB2 MAY TRAP IN SQLRA_GET_VAR WHEN HANDLING AN ERROR IF REOPT IS ENABLED.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Upon hitting a failure, error handling in sqlra_get_var may trap 
if REOPT is enabled. 
 
Typically the trap will be preceded by a db2diag.log messages 
indicating the error, e.g: 
 
2015-01-05-21.54.48.004039+480 I53168609A586      LEVEL: Error 
PID     : 11796724             TID  : 605440      PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-56850              APPID: x.x.x.x.xxxxx.xxxxxxxxxxxx 
AUTHID  : DB2INST1 
EDUID   : 605440               EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, access plan manager, 
sqlra_sqlC_acquire_sibling, probe:10 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap. 
 
Followed by: 
 
2015-01-05-21.54.48.004883+480 I53169729A574      LEVEL: Error 
PID     : 11796724             TID  : 605440      PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-56850              APPID: x.x.x.x.xxxxx.xxxxxxxxxxxx 
AUTHID  : DB2INST1 
EDUID   : 605440               EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, access plan manager, sqlra_get_var, probe:350 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap. 
 
The stack in the trap file may look like: 
 
sqlra_get_var 
sqlrr_process_execute_request 
sqlrr_execute 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 LUW with REOPT enabled.                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Version 9.7 Fix Pack 11.                           * 
****************************************************************
Local Fix:
N/A.
Solution
This problem is first fixed in DB2 Version 9.7 Fix Pack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.01.2015
22.10.2015
22.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList