|
Problem IC76391
|
Status: Closed |
ADMIN_GET_TAB_COMPRESS_INFO (ESTIMATE) CRASHES THE DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Admin compression estimate procedure may crash the database when
it's run against a table for which the online reorg is in
progress.
Following error will be reported in the db2diag.log:
2011-05-05-22.06.32.006167-300 I139110A555 LEVEL: Severe
PID : 10289174 TID : 32316 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-8903 APPID:
*LOCAL.db2inst1.110506030619
AUTHID : DB2INST1
EDUID : 32316 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldFetchOverflow,
probe:1798
MESSAGE : Followed REORGPOINTER but no OLR in progress!
DATA #1 : Hexdump, 8 bytes
0x07000001887EDFD0 : 0000 0000 0BD5 004E
.......N
2011-05-05-22.06.32.172071-300 I140579A533 LEVEL: Severe
PID : 10289174 TID : 32316 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
sample
APPHDL : 0-8903 APPID:
*LOCAL.db2sample.110506030619
AUTHID : DB2INST1
EDUID : 32316 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldFetchOverflow,
probe:1798
RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data
Page"
DIA8500C A data file error has occurred, record id is
"".
Callstack for EDU 32316 will show:
pthread_kill + 0xB0
sqloDumpEDU + 0x34
sqldDumpBadPage + 0x8A8
sqldFetchOverflow + 0x4C8
sqldReadNorm + 0x370
sqldFetchNext + 0x74
sqldfrd + 0x334
sqldBuildDictionary + 0x82C
sqldBuildDictionaryForEstimate + 0x8C
sqldGetDictionaryInfo + 0x77C
sqldGetTableData + 0x56C
sqlrlAdminGetTabInfo + 0x50 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP5 or higher *
**************************************************************** |
| Local Fix: |
Avoid running the admin compression estimate procedure while
online reorg is being run for the same table. Make sure reorg is
complete before running this procedure. |
| available fix packs: |
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 |
First Fixed in DB2 Version 9.7 Fix Pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.05.2011
15.02.2012
15.02.2012 |
| 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
|
 |
