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

REDISTRIBUTE CONTINUE ON TABLES WITH VALUE COMPRESSION FAILS WITH 901 ERROR
OR MAY CONTAIN EXTRA GARBAGE ROWS AFTER

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The problem occurs on compressed tables with VALUE COMPRESSION 
enabled or tables which have had their column definition altered 
prior to the redistribute. 
 
 
If the redistribute fails after the dictionary has been created 
on one of the new partitions, redistribute recovery may fail 
with a message similar to the one below in the db2diag.log: 
 
2010-09-08-00.53.48.878336-240 I1194890E1047 LEVEL: Error 
PID : 31958 TID : 47120606292288PROC : db2sysc 3 
INSTANCE: ebabani NODE : 003 DB : TESTDB 
APPHDL : 0-63 APPID: *N0.DB2.100908045348 
AUTHID : EBABANI 
EDUID : 141 EDUNAME: db2rwork 3 
FUNCTION: DB2 UDB, database utilities - Redistribute, 
sqlucCPageIterator::zNextRecord, probe:2359 
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT 
"SQLCA has already been built" 
DATA #1 : RDSTID, PD_TYPE_RDSTID, 39 bytes 
RDSTID: C.55.20100908005340.0|129(3;4)| 
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 29 
sqlerrmc: Unexpected compressed record 
sqlerrp : SQLUCPAG 
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000 
(4) 0x00000000 (5) 0x00000000 (6) 0x00000003 
sqlwarn : (1) (2) (3) (4) (5) (6) 
(7) (8) (9) (10) (11) 
sqlstate: 
 
It is also possible but less likely that redistribute recovery 
will continue, but the dictionary will not be saved on the new 
partitions. As a result garbage rows will be seen in the table 
on the new database partitions.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Any user using DB2 v970 FP3a or lower                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* REDISTRIBUTE CONTINUE ON COMPRESSED TABLES WITH VALUE        * 
* COMPRESSION FAILS WITH 901 ERROR                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrading to DB2 v970 FP4 or higher                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC73188 IC74617 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.09.2010
28.04.2011
28.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0
Problem behoben lt. FixList in der Version
9.7.0.4 FixList