IBM Support

IC77676: ACTIVITIES EVENT MONITOR CORRECTLY RECORDS ONLY THE FIRST REOPT DATA VALUE; ANY OTHER REOPT VALUE RESHOWS THE FIRST VALUE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When an activities event monitor is active and activity with
    details and values collection is enabled, any activity that has
    been subject to reoptimization and has more than one data value
    will correctly records only the first reoptimized data value.
    For any other reoptimized data value the first data value is
    shown again rather than the correct value.
    

Local fix

  • db2pd db <dbName> -reopt will correctly show all the reopt data
    values.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Anybody using the activities event monitor and REOPT         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If an activity has been re-optimized and has more than one   *
    * data value, the first reopt data value is properly recorded. *
    * The second data value and any other will report the first    *
    * value's information.                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 Fix Pack 5                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77676

  • 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

    2011-07-22

  • Closed date

    2011-12-21

  • Last modified date

    2011-12-21

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

  • 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 PSN

       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:
21 December 2011