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 IT09420 Status: Geschlossen

IN DB2DIAG.LOG INFORMATION "DEFERRED ADC IS SKIPPED DUE TO PRIOR
ERROR" MIGHT BE REPORTED FOR GLOBAL TEMPORARY TABLE WITH INDEX

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 7                   * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.06.2015
20.01.2016
20.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList