IBM Support

PI22615: ROLLUP ACCOUNTING RECORDS (FOR REASON QWACRSTL / QWACRSTG ) NOT ALWAYS WRITTEN WHEN TRACE IS QUALIFIED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using a filter on the accounting trace (eg. -STA TRA(A)
    PLAN(DISTSERV) ) together with rollup accounting ( ACCUMACC > 1
    ), accounting records ( IFCID3 ) are not always written when
    the record is written for reason staleness ( QWACRSTL ) or
    storage ( QWACRSTG )  ( QWACRINV = 3 or 2 ).
    

Local fix

  • Don't qualify the accounting trace
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users of accounting records  *
    *                 and/or correlating token is not correct      *
    *                 QWACPACE                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Rollup accounting records not always *
    *                      written when the trace is qualified due *
    *                      to reason QWACRSTL/QWACRSTG             *
    *                                                              *
    *                      2. Token used to correlate a task is    *
    *                      not correct in the accounting trace     *
    *                      record QWACPACE                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1. During retrieval of accounting records (IFCID0003), some
    records were not being produced and instead were being filtered
    out during the qualification process.
    .
    DB2 v10 has internal blocks for accounting trace records that
    were moved above the bar while the code was still looking into
    the previous storage area. When looking into the incorrect
    area, some SMF records may look to be QWACRSTG or QWACRSTL and
    caused DB2 to skip these records.
    .
    2. QWACPACE is used as the token to correlate a parallel,
    utility subtask or autonomous transaction rollup record. When
    DB2 v10 code looked at the previous storage area as detailed
    in section 1, QWHCAACE can report the token of the current
    running task, instead of the correct QWACPACE expected.
    

Problem conclusion

  • SOLUTION: DB2 has been modified to address the correct block
    for properly qualified records and report the correct
    token to correlate.
    
    KEYWORDS: IFCID 0003
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI22615

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-25

  • Closed date

    2014-09-10

  • Last modified date

    2015-01-02

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

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

    UI21287

Modules/Macros

  • DSNB1CMU DSNB1DGB DSNB1DRA DSNB1DUP DSNB1FLW
    DSNB1GBR DSNB1GET DSNB1GRC DSNB1LDN DSNB1LTS DSNB1LTX DSNB1PPG
    DSNB1SSR DSNB1TGB DSNB1TSD DSNB5BPL DSNB5CMX DSNB5COM DSNB5DEL
    DSNB5GBG DSNB5GGP DSNB5PCO DSNB5PGB DSNB5RAP DSNB5RDP DSNB5SCM
    DSNB5SCO DSNB5SC1 DSNB5SC2 DSNB5STS DSNB5ULK DSNB5WCS DSNJC005
    DSNJC007 DSNJR006 DSNJR007 DSNJW001 DSNJW101 DSNKLTCH DSNLCITR
    DSNLCMBE DSNLCSRR DSNLCVTR DSNRUB01 DSNTLSUS DSNVEUS1 DSNVSLT0
    DSNVXLT0 DSNWVAPR DSNWVCOL DSNWVZD1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI21287

       UP14/09/27 P F409

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:
02 January 2015