| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC75598 | Status: Closed |
REDISTRIBUTE CRASH WITH SQL0901 DUE TO INCORRECT PAGE CHECK | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
When processing pages on a sender partition it is possible for
redistribute to fail due to an incorrect free space check on one
of the pages.
This situation occurs rarely but affects all types of tables.
Only NOT ROLLFORWARD RECOVERABLE redistribute is affected and
the problem can be identified by a message similar to the one
below in the db2diag.log
2010-05-18-15.39.34.966875-240 I220570E1538 LEVEL: Error
PID : 22913 TID : 183127501152 PROC :
db2sysc 4
INSTANCE: test NODE : 004 DB : TESTDB
APPHDL : 1-3788 APPID: *N1.DB2.100518193526
AUTHID : TEST
EDUID : 4599 EDUNAME: db2rwork 4
FUNCTION: DB2 UDB, database utilities - Redistribute,
sqlucCPage::zInsertRecordAtSlot, probe:866
MESSAGE :
ZRC=0x82B00001=-2102394879=SQLUC_ZRC_ERROR_GENERIC_PROGRAMMING_E
RROR
"Non-severe error encountered during redistribute.
Request is failed."
DIA8532C An internal processing error has occurred.
DATA #1 : RDSTID, PD_TYPE_RDSTID, 43 bytes
RDSTID: C.1869.20100518153450.1|4546(6;22)|
DATA #2 : File name, 11 bytes
sqlucPage.C
DATA #3 : String, 36 bytes
Inserting into invalid place on page
DATA #4 : unsigned integer, 2 bytes
238
DATA #5 : unsigned integer, 8 bytes
106
DATA #6 : unsigned integer, 2 bytes
343
DATA #7 : unsigned integer, 4 bytes
16384
DATA #8 : unsigned integer, 2 bytes
186
DATA #9 : unsigned integer, 2 bytes
9670
DATA #10: unsigned integer, 8 bytes
16316
DATA #11: Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:6;obj:22;type:0} PPNum:1404482 OPNum:285058
begoff: 48
datlen: 16336
pagebinx: 173894
revnum: 1024
pagelsn: 0E92A1BE884B flag: a
signature: 2392513016
cbits1to31: 30b668c5
cbits32to63: 0 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Redistribute * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 Fix Pack 5 * **************************************************************** | |
| Local Fix: | |
Issue a REDISTRIBUTE ABORT. Issue a REORG TABLE on the affected table prior to running redistribute again. | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Solution | |
Problem fixed in DB2 V9.7 Fix Pack 5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.04.2011 09.12.2011 09.12.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.5 |
|