|
Problem IC71104
|
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 / 970 - 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: *
* 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: |
|
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73188 IC74617
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2010
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
