|
Problem IC69651
|
Status: Geschlossen |
DURING DATABASE UPGRADE, INCORRECT RUNSTATS COMMAND ON CATALOG TABLE MAY BE GENERATED DUE TO STATS PD CORRUPTION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| verfügbare FixPacks: |
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
|
| Lösung |
Fixed in DB2 V9.7 Fixpack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.07.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
