|
Problem IC74617
|
Status: Closed |
REDISTRIBUTE CONTINUE ON TABLES WITH VALUE COMPRESSION FAILS WITH 901 ERROR OR MAY CONTAIN EXTRA GARBAGE ROWS AFTER |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of redistribute *
****************************************************************
* PROBLEM DESCRIPTION: *
* See error description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.5 FP8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem fixed in DB2 V9.5 FP8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.02.2011
27.06.2011
27.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
