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

LOAD JOB FAILS OR HANGS AFTER HITTING ADC ERROR SHOWN IN DB2DIAG.LOG

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
A load job against a table created with "COMPRESS YES" can fail 
or hang 
after hitting the following ADC error shown in db2diag.log: 
 
2010-01-07-08.44.08.521591-300 I32017E551          LEVEL: Error 
PID     : 23633                TID  : 183257524576 PROC : 
db2sysc 1 
INSTANCE: dbguest3             NODE : 001          DB   : 
DB55864 
APPHDL  : 0-59                 APPID: *N0.dbguest3.100107134259 
AUTHID  : DBGUEST3 
EDUID   : 125                  EDUNAME: db2lrid 1 
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 132 bytes 
LOADID: 34.2010-01-07-08.43.59.410542.0 (2;4) 
ADC: Cannot build dictionary! , 263203, 0x8000, Detected in 
file:sqlulrid.C, Line:6412 
 
2010-01-07-08.44.08.526834-300 I32569E553          LEVEL: Error 
PID     : 23633                TID  : 183257524576 PROC : 
db2sysc 1 
INSTANCE: dbguest3             NODE : 001          DB   : 
DB55864 
APPHDL  : 0-59                 APPID: *N0.dbguest3.100107134259 
AUTHID  : DBGUEST3 
EDUID   : 125                  EDUNAME: db2lrid 1 
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 134 bytes 
LOADID: 34.2010-01-07-08.43.59.410542.0 (2;4) 
ADC: failed to build dictionary! , 263203, (nil), Detected in 
file:sqlulrid.C, Line:2825
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* LOAD JOB HANGS AFTER HITTING ADC ERROR SHOWN IN DB2DIAG.LOG  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.5 Fix Pack  6                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.5 Fix Pack 6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.01.2010
10.06.2010
08.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.,
9.5.FP6
Problem behoben lt. FixList in der Version