IBM Support

IC72854: DB2EXPLN -PACKAGE GIVES ERROR 'UNABLE TO COLLECT SECTION ACTUAL STATISTICS'

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

  • Disregard this diagnostic message.
    

Problem summary

  • ****************************************************************
    * 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.           *
    ****************************************************************
    

Problem conclusion

  • Using DB2 V97 FP4 or later does show the correct values
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC72854

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-11-29

  • Closed date

    2011-05-16

  • Last modified date

    2011-05-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC73129

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 May 2011