|
Problem IC69651
|
Status: Closed |
DURING DATABASE UPGRADE, INCORRECT RUNSTATS COMMAND ON CATALOG TABLE MAY BE GENERATED DUE TO STATS PD CORRUPTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When upgrading a v8 database, if there exists corruption in the
table stats packed descriptor, incorrect Runstats command may
get generated during database upgrade causing warning SQL1499W
to be returned.
The below entry will be inside the administration notification
log:
ADM4101W The UPGRADE DATABASE command failed to automatically
collect statistics on the "SYSCOLDIST" system catalog table. The
following RUNSTATS command returned SQLCODE "-104" with tokens
"AND <identifier> " :
"RUNSTATS ON TABLE "SYSIBM"."SYSCOLDIST" WITH DISTRIBUTION ON
COLUMNS () AND DETAILED INDEXES "SYSIBM"."INDCOLDIST01"".
DB2DAIG.LOG Entry
FUNCTION: DB2 UDB, catalog migration, sqlrlmInvokeRunstats,
probe:7228
MESSAGE : ADM4101W The UPGRADE DATABASE command failed to
automatically
collect statistics on the "SYSPARTITIONMAPS" system
catalog table.
The following RUNSTATS command returned SQLCODE "-104"
with tokens
"AND <identifier> " : "RUNSTATS ON TABLE
"SYSIBM"."SYSPARTITIONMAPS"
WITH DISTRIBUTION ON COLUMNS () AND INDEXES
"SYSIBM"."INDPARTITIONMAPS01"". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* When upgrading a v8 database, if there exists corruption in *
* the *
* table stats packed descriptor, incorrect Runstats command *
* may *
* get generated during database upgrade causing warning *
* SQL1499W *
* to be returned. *
* *
* *
* *
* The below entry will be inside the administration *
* notification log: *
* *
* *
* *
* ADM4101W The UPGRADE DATABASE command failed to *
* automatically collect statistics on the "SYSCOLDIST" system *
* catalog table. *
* The following RUNSTATS command returned SQLCODE "-104" with *
* tokens "AND <identifier> " : *
* *
* "RUNSTATS ON TABLE "SYSIBM"."SYSCOLDIST" WITH DISTRIBUTION *
* ON *
* COLUMNS () AND DETAILED INDEXES "SYSIBM"."INDCOLDIST01"". *
* *
* *
* *
* *
* *
* DB2DAIG.LOG Entry *
* *
* *
* *
* FUNCTION: DB2 UDB, catalog migration, sqlrlmInvokeRunstats, *
* probe:7228 *
* *
* MESSAGE : ADM4101W The UPGRADE DATABASE command failed to *
* automatically *
* *
* collect statistics on the "SYSPARTITIONMAPS" *
* system catalog table. *
* *
* The following RUNSTATS command returned SQLCODE *
* "-104"with tokens *
* *
* "AND <identifier> " : "RUNSTATS ON TABLE *
* "SYSIBM"."SYSPARTITIONMAPS" *
* WITH DISTRIBUTION ON COLUMNS () AND INDEXES *
* *
* "SYSIBM"."INDPARTITIONMAPS01"". *
****************************************************************
* RECOMMENDATION: *
* Run Runstats on all catalog tables on v8 prior to the *
* upgrade or ignore the warning message and *
* run Runstats on the failing catalog table after upgrade *
**************************************************************** |
| Local Fix: |
Run Runstats on all catalog tables on v8 prior to the upgrade or
ignore the warning message and run Runstats on the failing
catalog table after upgrade |
| 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 |
Fixed in DB2 V9.7 Fixpack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.07.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
