IBM Support

IC82432: IF THE TOTAL NUMBER OF STATISTIC EVENT LOG FILES IS 15, DB2DIAG AND PD_GET_DIAG_HIST FAIL TO RETRIEVE DATA.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • We can specify the max number of statistic event log is 15 (e.g.
    db2set DB2_OPTSTATS_LOG=ON,NUM=15 ) but when the total number of
    statistic event log files reached is 15 ( e.g.:
    db2optstats.0.log , ... , db2optstats.14.log ), db2diag command
    and PD_GET_DIAG_HIST against statistic event log will fail to
    retrieve any data.
    
    Example:
    
    >db2diag -fac optstats -c
    db2diag: No messages found for facility "optstats".
    
    >db2 "SELECT FACILITY, RECTYPE, TIMESTAMP, IMPACT, SUBSTR(MSG,1,
    50) AS MSG FROM TABLE (PD_GET_DIAG_HIST( 'OPTSTATS', 'E', '',
    NULL, NULL) )"
    SELECT FACILITY, RECTYPE, TIMESTAMP, IMPACT, SUBSTR(MSG,1, 50)
    AS MSG FROM TABLE (PD_GET_DIAG_HIST( 'OPTSTATS', 'E', '', NULL,
    NULL) )
    
    FACILITY             RECTYPE TIMESTAMP                  IMPACT
    MSG
    -------------------- ------- --------------------------
    ------------------
    --------------------------------------------------
    
      0 record(s) selected.
    

Local fix

  • Remove any older statistic event log files so the total number
    of logs is 15 or less.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 9.7 FP7 or subsequent fix pack                    *
    ****************************************************************
    

Problem conclusion

  • First Fixed In DB2 Version 9.7 Fix Pack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82432

  • 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

    2012-04-02

  • Closed date

    2013-01-17

  • Last modified date

    2013-01-17

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

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

    IC84611 IC87833

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC82432

Modified date: 17 January 2013