DB2 FOR LUW / DB2FORLUW / 970 - DB2

DPF systems with applications that use both Declared Global 
Temporary Tables (DGTTs) and Created Global Temporary 
Tables (CGTTs) can encounter a problem where 
sqlrl_userTempPostCleanup() is called twice, once for DGTTs and 
once for CGTTs. A DGTT failure results 
in the skipping of the CGTT cleanup, which leads to unexpected 
cleanup entries on a subsequent cleanup.  The main symptom is a 
-901 error, the diaglog entry looks like the following: 
 
2012-02-14-09.47.09.961625-300 I26054932E884       LEVEL: Severe 
PID     : 11059                TID  : 47246934534464PROC : 
db2sysc 1 
INSTANCE: instname             NODE : 001          DB   : 
databasename 
APPHDL  : xxxxx                APPID: xx.xx.xx.xx.xx 
AUTHID  : authid 
EDUID   : 21999                EDUNAME: db2agent (databasename) 
1 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 49 
 sqlerrmc: sqlrl_userTempCleanup: unexpected cleanup entries 
 sqlerrp : SQLRL2C3 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFFD      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2FORLUW                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP6 or later                              * 
****************************************************************

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
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84446 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.02.2012
30.07.2013
30.07.2013

9.7.FP6