IBM Support

IC65811: "SHOW EXPLAINED STATEMENTS HISTORY" FROM CC IS NOT LISTED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After migrating to V9.1 Fix Pack 6 the option "Show Explained
    Statement History" in the Control Center does not list the
    access plans that was created in V8.
    
    If an access plan is created in the V9.1, the data is returned
    in the option, but not those that was created in V8.
    
    The explain tables are populated (EXPLAIN_INSTANCE and
    EXPLAIN_STATEMENT).
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using DB2 9.7                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * "SHOW EXPLAINED STATEMENTS HISTORY" FROM CC IS NOT LISTED.   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply DB2 V9.7 FP2                                           *
    ****************************************************************
    

Problem conclusion

  • After migrating to V9.1 Fix Pack 6 the option "Show Explained
    
    Statement History" in the Control Center does not list the
    
    
    access plans that was created in V8.
    
    If an access plan is created in the V9.1, the data is returned
    
    
    in the option, but not those that was created in V8.
    
    
    
    The explain tables are populated (EXPLAIN_INSTANCE and
    EXPLAIN_STATEMENT).
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65811

  • 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-01-25

  • Closed date

    2010-05-14

  • Last modified date

    2010-05-14

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

    JR33132

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
14 May 2010