IBM Support

PM74961: ALAA440E OR MISSING DATA WHEN REPORTING ON ROLLED BACK UNITS OF WORK THAT SPAN DB2 LOGS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Log Analysis Tool was not distinguishing between rollback to
    savepoint log records and aborted UOW log records when the UOW
    crossed DB2 logs. This could lead to messages like ALAA440E and
    ALAA447E or just not reporting some activity in an aborted UOW.
    This would only happen if tracking aborted units of work.
    

Local fix

  • To avoid this issue, temporarily suspend tracking aborted units
    of work.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 Log Analysis Tool was not           *
    *                      distinguishing between rollback to      *
    *                      savepoint log records and aborted UOW   *
    *                      log records when the UOW crossed DB2    *
    *                      logs. This could lead to messages like  *
    *                      ALAA440E and ALAA447E or just not       *
    *                      reporting some activity in an aborted   *
    *                      UOW. This would only happen if          *
    *                      tracking aborted units of work.         *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM74961

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-10-12

  • Closed date

    2012-11-08

  • Last modified date

    2012-12-04

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

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

    UK83357 UK83358

Modules/Macros

  •    ALAPGR   ALASUBG  ALAURC
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R320 PSY UK83357

       UP12/11/15 P F211

  • R330 PSY UK83358

       UP12/11/15 P F211

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"320"}]

Document Information

Modified date:
12 April 2021