Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.