IBM Support

PM62797: AGGREGATE ACCOUNTING STATISTICS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Aggregate Accounting Statistics IFCID003
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS.                *
    ****************************************************************
    * PROBLEM DESCRIPTION: Performance analysis often requires     *
    *                      the aggregation of accounting data      *
    *                      over an interval.  Aggregating          *
    *                      accounting data for analysis is a       *
    *                      manual, time consuming process.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Automated aggregation of accounting data is desired.
    

Problem conclusion

Temporary fix

Comments

  • New accounting aggregation functionality is introduced in this
    APAR giving DB2 the ability to aggregate accounting data
    into an IFC statistics record. To enable the new function,
    IFCID3 and IFCID369 must be enabled on the system.  When
    both of these IFCIDs are ON, DB2 will aggregate QWAC and QWAX
    data for each transaction grouped by connection type.
    
    This statistics information will then be externalized in an
    IFCID369 at the statistics interval or via an IFCID READS call.
    It should be noted that the statistics interval for IFCID369 is
    fixed at 1 minute.
    
    A new statistics class 9 is created to encapsulate IFCID369.
    
    See DSNDQW05 macro for the mapping of IFCID369.
    

APAR Information

  • APAR number

    PM62797

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-18

  • Closed date

    2012-08-10

  • Last modified date

    2012-09-05

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

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

    UK81047

Modules/Macros

  • DSNDQWAC DSNDQWAX DSNDQW05 DSNTXSTA DSNTXSTB
    DSNWARDS DSNWVCSP DSNWVCST DSNWVINT DSNWVZCK DSNWVZIT DSNWVZPS
    DSNWVZSA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK81047

       UP12/08/29 P F208

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 September 2012