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 | |
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 |