DB2 FOR LUW / DB2FORLUW / A10 - DB2

After update to DB2 10.1 Fix Pack 4 you might notice information 
in db2diag.log within GLOBAL TEMPORARY TABLE usage with index 
access attempt when inserting data into table. 
 
Information with error about the index missing in db2diag.log 
are similar to the following: 
 
2015-01-28-18.19.08.875000+180 I599854142F590       LEVEL: Info 
PID     : 12345                TID : 1234           PROC 
:db2syscs.exe 
INSTANCE: DB2INST1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-200                APPID: 
127.0.0.1.54321.150101012345 
AUTHID  : DB2ADMIN             HOSTNAME: MYHOST 
EDUID   : 4321                 EDUNAME: db2agent (DB) 0 
FUNCTION: DB2 UDB, data management, sqldRowInsert, probe:5541 
MESSAGE : ZRC=0x8404007E=-2080112514=SQLD_IXNOEX "INDEX DOES NOT 
EXIST" 
DATA #1 : String, 42 bytes 
Deferred ADC is skipped due to prior error 
 
This might show up for a DECLARE GLOBAL TEMPORARY TABLE 
statement, when specifying clauseNOT LOGGED with ON ROLLBACK 
DELETE ROWS which is the default option for it. When index 
object were marked invalid with next insert,  sqldRowInsert will 
get SQLD_IXNOEX, which will lead to a higher layer of DB2 
recreating the index object as update. This causes no problem in 
the database other than the db2diag.log message.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 and Fix Pack 5                   * 
****************************************************************

Problem was first fixed in DB2 Version 10.1 and Fix Pack 5

keiner bekannt / siehe Local-Fix

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

17.03.2015
13.07.2015
13.07.2015