IBM Support

PM29200: MSGALAA447E DUE TO SEGMENTED TABLESPACE AND ORDER OF UPDATES.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • MSGALAA447E due to segmented tablespace and order of updates.
    If a segmented tablespace has more than one table, and more than
    one table has been updated for the run, an ALAA447E message
    is possible depending on the particular order of updates.
    

Local fix

  • Log-backward may work with no other modifications to the job,
    assuming log-backward is possible for the job (eg.no REORGs
    since the timeframe,etc).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: MSGALAA447E due to segmented            *
    *                      tablespace and order of updates. If a   *
    *                      segmented tablespace has more than one  *
    *                      table, and more than one table has      *
    *                      been updated for the run, an ALAA447E   *
    *                      message is possible depending on the    *
    *                      particular order of updates.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM29200

  • 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

    2010-12-17

  • Closed date

    2011-02-14

  • Last modified date

    2011-03-02

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

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

Modules/Macros

  •    ALACRRF
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R310 PSY UK64826

       UP11/02/22 P F102

  • R320 PSY UK64827

       UP11/02/22 P F102

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:
18 March 2021