****************************************************************
* USERS AFFECTED: *
* All DB2 users prior to DB2 9.7 FP3 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Problem arises when db2dart tries to uncompress a compressed *
* record as part of data dumping. db2dart will output an *
* "Error expanding row." when this problem occurs. The amount *
* of usable data reported by dart will also be greatly *
* diminished. The error will also be caught in db2diag.log, *
* where "sqldExpandRec" will produce an error, stating there *
* was a "Failure expanding record". *
* *
* Example below, when "db2dart /DD" command is given. First is *
* the output from the command, then the db2diag.log output. *
* *
* db2dart /DD: *
* *
* --------------------------------------------------------------
* Connecting to Buffer Pool Services... *
* *
* Table object report phase start. *
* Formatted data being dumped to report... *
* Dump format is verbose. *
* *
* Dumping... *
* Dumping... *
* Dumping... *
* Dumping... *
* Dumping... *
* Dumping... *
* Dumping... *
* Error: Error expanding row. Page 6, pool page 198, of *
* *
* Object 4, in tablespace 2. *
* Error: Page data will be dumped to report. *
* *
* Dumping... *
* Error: Error expanding row. Page 7, pool page 199, of *
* *
* Object 4, in tablespace 2. *
* Error: Page data will be dumped to report. *
* Dumping... *
* Error: Error expanding row. Page 8, pool page 200, of *
* *
* Object 4, in tablespace 2. *
* Error: Page data will be dumped to report. *
* Dumping... *
* Error: Error expanding row. Page 9, pool page 201, of *
* *
* Object 4, in tablespace 2. *
* Error: Page data will be dumped to report. *
* Dumping... *
* Error: Error expanding row. Page 10, pool page 202, of *
* *
* Object 4, in tablespace 2. *
* Error: Page data will be dumped to report. *
* Table object report phase end. *
* *
* ______________________________________ *
* *
* *
* DB2DART Processing completed with error! *
* Error(s) detected during processing. *
* ______________________________________ *
* *
* Complete DB2DART report found in: *
* TCDB.RPT *
* *
* _______ D A R T P R O C E S S I N G C O M P L E T E *
* ____ *
* *
* *
* db2diag.log: *
* *
* 2010-08-24-15.21.53.443420-240 I47978E1315 LEVEL: *
* Severe *
* PID : 19448 TID : 47509230979824 PROC : *
* db2dart *
* INSTANCE: tcosgrov NODE : 000 *
* FUNCTION: DB2 UDB, data management, sqldExpandRec, *
* probe:1500 *
* MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR *
* "non-severe dms programming error" *
* DIA8532C An internal processing error has *
* occurred. *
* DATA #1 : String, 24 bytes *
* Failure expanding record *
* DATA #2 : String, 13 bytes *
* sqldExpandRec *
* CALLSTCK: *
* [0] 0x00002B358F61946D pdLog + 0x3A3 *
* [1] 0x00002B3591F2281D sqlzSetAndLog901 + 0x1FF *
* [2] 0x00002B358F7F49AA *
* _Z13sqldExpandRecP8sqeAgentP8SQLD_TCBP18SQLD_TCB_DICT_INFOmP13
* + 0x468 *
* [3] 0x00002B3590CAAF8A sqldExpandFullRecOverrideDict + *
* 0x2C *
* [4] 0x0000000000435FB6 *
* _Z19DartExpandDATRecordP17DartControlStructP12SQLD_REC_HDRP12D
* + 0x152 *
* [5] 0x000000000042F9CE *
* _Z8dumpdrecP12SQLO_FHANDLEP17DartControlStructP12DartPageDesci
* + 0x5D18 *
* [6] 0x0000000000428CC9 *
* _Z24DartDumpFormattedDATPageP12SQLB_GLOBALSP17DartControlStruc
* + 0x699 *
* [7] 0x000000000041EC57 *
* _Z19DartMGRDumpDATPagesP12SQLB_GLOBALSP17DartControlStructP12S
* + 0x783 *
* [8] 0x0000000000417F75 DartMGRMain + 0xDF3 *
* [9] 0x000000000040E18C main + 0x16A4 *
* *
* 2010-08-24-15.21.53.448771-240 I49294E1377 LEVEL: *
* Error *
* PID : 19448 TID : 47509230979824 PROC : *
* db2dart *
* INSTANCE: tcosgrov NODE : 000 *
* FUNCTION: DB2 UDB, data management, sqldExpandRec, *
* probe:1500 *
* DATA #1 : String, 19 bytes *
* SQLD_TCB_DICT_INFO: *
* DATA #2 : Hexdump, 88 bytes *
* 0x00002B359AF72140 : 0000 0000 0000 0000 8062 F69D 352B 0000 *
* .........b..5+.. *
* 0x00002B359AF72150 : 8030 F69D 352B 0000 0000 0600 0000 0000 *
* .0..5+.......... *
* 0x00002B359AF72160 : 0000 0000 0200 0000 0000 0000 25B2 0300 *
* ............%... *
* 0x00002B359AF72170 : 0000 0000 0200 0000 3831 0000 0034 0000 *
* ........81...4.. *
* 0x00002B359AF72180 : E105 6A69 AC81 5003 AE1B 744C E903 0000 *
* ..ji..P...tL.... *
* 0x00002B359AF72190 : 1000 0000 4040 0000 *
* ....@@.. *
* DATA #3 : String, 21 bytes *
* Expansion Dictionary: *
* DATA #4 : Dumped object of size 12600 bytes at offset 0, 58 *
* bytes *
* /home/hotel72/tcosgrov/sqllib/db2dump/19448.0.000.dump.bin *
* DATA #5 : String, 18 bytes *
* Compressed Record: *
* DATA #6 : Hexdump, 15 bytes *
* 0x0000000000742D4C : 8100 0F00 1281 1B11 9125 1271 2012 20 *
* .........%.q . *
* DATA #7 : String, 18 bytes *
* Outer record type: *
* DATA #8 : unsigned integer, 8 bytes *
* 0 *
* DATA #9 : String, 23 bytes *
* Expanded Record Length: *
* DATA #10: unsigned integer, 8 bytes *
* 35 *
* DATA #11: String, 18 bytes *
* Max Record Length: *
* DATA #12: unsigned integer, 4 bytes *
* 0 *
****************************************************************
* RECOMMENDATION: *
* To resolve the problem, either: *
* *
* 1) Uncompress records before running db2dart on them. *
* *
* OR *
* *
* 2) Upgrade to product verson v97 Fix Pack 3. *
**************************************************************** |
