DB2 FOR LUW / DB2FORLUW / 970 - DB2

If db2expln is issued for a package the following output may 
occur for several sections: 
 
Estimated Cost = 0.000000 
Estimated Cardinality = 0.000000 
 
Unable to collect section actual statistics 
 
To reproduce this do 
 
db2expln -database sample -package % -schema % -output 
/tmp/file.out 
 
This message does not occur under DB2 9.7 GA , but can be seen 
with FP1 and FP2

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2expln users after V97GA.                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2expln issued for a package can lead to wrong information  * 
* about estimated cost and estimated cardinality .             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 97FP4 or later, which contain this fix.           * 
****************************************************************

Disregard this diagnostic message.

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
 

Using DB2 V97 FP4 or later does show the correct values

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC73129 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.11.2010
16.05.2011
16.05.2011

9.7.FP4