Skip to main content

PQ99658: AVAILABILITY OF STORAGE DIAGNOSTIC RECORD IFCID225

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Availability of Storage Diagnostic Record IFCID 225.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: IFCID 225 is needed to evaluate most    *
    *                      critical storage issues.  Since this    *
    *                      record is part of STATISTICS trace      *
    *                      class 6, it is often not ON during      *
    *                      a first failure.  In addition, since    *
    *                      IFCID 225 is most often collected at    *
    *                      a default statistics interval of 30     *
    *                      minutes, the large time differential    *
    *                      between records reduces their           *
    *                      diagnostic value.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Enhancements are needed to ensure the availability of IFCID
    225 records on first failure.
    

Problem conclusion

  • 1. System parameter STATIME default time is reduced from 30
       minutes to 5.
    2. IFCID 225 is added to STATISTICS trace class 1.
    3. An internal cache of IFCID 225 records is being kept so
       storage changes over time can be evaluated during dump
       analysis.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PQ99658

  • Reported component name

    5740 IBM DATABA

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-01-18

  • Closed date

    2005-06-10

  • Last modified date

    2005-07-01

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

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

    UK04393 UK04394

Modules/Macros

  • DSNCIM   DSNCIMX  DSNDIAMQ DSNDQWST DSNDWWCB
    DSNTIDXA DSNTIJUZ DSNTXSTB DSNWVINT DSNWVSBH DSNWVZCK DSNWVZIT
    DSNWVZXT DSN6SYSP
    

Fix information

  • Fixed component name

    5740 IBM DATABA

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R710 PSY UK04393

       UP05/06/28 P F506

  • R810 PSY UK04394

       UP05/06/28 P F506

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page

Please take a moment to complete this form to help us better serve you.

This material provides me with the information I need.






This material is clear and easy to understand.






Did the information help you to achieve your goal?

What updates, improvements, or related information would you like to see in this document?

Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.


Input the verification number to submit feedback:



Document information

Product categories:

Software

Data Management

Data Servers (Database Management Systems)

DB2 for z/OS


Software version:

810


Reference #:

PQ99658


IBM Group:

Software Group


Modified date:

2005-07-01

Translate my page