home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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 FixList