IBM Support

PI87027: MESSAGE ALAA073E WHEN TABLE VERSIONING, FULL ROW IMAGES, AND A CHANGE IN COMPRESSION DICTIONARY OCCURS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If there is table versioning present, full row images, and a
    change in dictionary that is not found in the Image Copy prior
    to the activity then message ALAA073E will be issued. The
    compression dictionary was built before the activity but was
    not copied into an image copy until after the activity occurred.
    Under these circumstances the processing was using the current
    compression dictionary from the TABLESPACE which was not
    correct.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Uaers of ALA 350                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:   PI87027                               *
    *                                                              *
    *                      If there is table versioning present,   *
    *                      full row images, and a                  *
    *                      change in dictionary that is not found  *
    *                      in the Image Copy prior                 *
    *                      to the activity then message ALAA073E   *
    *                      will be issued. The                     *
    *                      compression dictionary was built before *
    *                      the activity but was                    *
    *                      not copied into an image copy until     *
    *                      after the activity occurred.            *
    *                      Under these circumstances the           *
    *                      processing was using the current        *
    *                      compression dictionary from the         *
    *                      TABLESPACE which was not                *
    *                      correct.                                *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI87027

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-07

  • Closed date

    2017-09-27

  • Last modified date

    2017-11-01

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

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

Modules/Macros

  •    ALALF1A
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI50663

       UP17/10/07 P F710

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

Document Information

Modified date:
30 March 2021