IBM Support

PM26353: MESSAGE ALAA447E WITH PARTITIONED TABLE IN LOG-FORWARD MODE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ALAA447E msg indicating ROWDATA validation error may occur when
    using a partitioned table and multiple image copies are needed
    to resolve all full row images. Will occur if the first image
    copy accessed resolves all rows in an earlier partition (e.g.,
    partition number 1), and a subsequent image copy resolves rows
    in a subsequent partition (e.g., partition number 2 or higher).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Log Analysis Tool               *
    ****************************************************************
    * PROBLEM DESCRIPTION: ALAA447E msg indicating ROWDATA         *
    *                      validation error may occur when using   *
    *                      a partitioned table and multiple image  *
    *                      copies are needed to resolve all full   *
    *                      row images. Will occur if the first     *
    *                      image copy accessed resolves all rows   *
    *                      in an earlier partition (e.g.,          *
    *                      partition number 1), and a subsequent   *
    *                      image copy resolves rows in a           *
    *                      subsequent partition (e.g.,             *
    *                      partition number 2 or higher).          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Apply the PTF.
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM26353

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-11-09

  • Closed date

    2011-01-12

  • Last modified date

    2011-02-02

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

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

Modules/Macros

  •    ALA@FSP
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R310 PSY UK63904

       UP11/01/19 P F101

  • R320 PSY UK63905

       UP11/01/19 P F101

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":"310"}]

Document Information

Modified date:
30 March 2021