DB2 - Problembeschreibung
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 | |
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 |