Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC61995 Status: Closed

MIMIC STAT GENERATED BY DB2LOOK -M OPTION IS INCORRECT

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
The SQL statement(UPDATE SYSSTAT.INDEXES) generated by db2look 
with -m option  is not correct. 
SQL1227N  The catalog statistic "-1.000000" for column 
"DATAPARTITION_CLUSTERFACTOR" is out of range for its target 
column.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* software                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* mimic stat generated by db2look was incorrect                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* customer has to move to v95 fp5 to over come this problem    * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
this has been fixed in v95 fp5
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC62686 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.07.2009
05.02.2010
05.02.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.5.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.