home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT06532 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
Lösung
This problem is first fixed in DB2 Version 9.7 Fix Pack 11.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.01.2015
22.10.2015
22.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList