IBM Support

PM33480: VARIOUS ABEND0C4 ABENDS EXECUTING AFTER UPDATE TRIGGER WITH MANY COLUMNS IN THE TABLE. DB2OVRLAY/K

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An UPDATE AFTER TRIGGER was defined on a table with many
    columns.  This caused the internal length of an SQLDA to be
    larger than woud fit in a 2-byte length field, resulting in
    an overlay.  SMCOVERLAY
    Abends were observed in the follow areas:
    ABEND0C4 RC00000038 DSNB1RTR OFFSET 03B4 OFFSET03B4
    ABEND0C4 RC00000010 DSNSVBK  OFFSET 0E2A OFFSET0E2A
    ABEND04E RC00C90101 DSNIWKFD VRACE5001 ERUAL5001
    ABEND0C4 RC00000004 DSNIMOFT OFFSET 2DF0 OFFSET2DF0
    ABEND0C4 RC00000038 DSNXGRDS DSNXEXAT OFFSET7D8E
    ABEND04E RC00E20006 DSNIBABR DSNSVBK OFFSET1CDC
    ABEND0C4 RC00000038 DSNIDM  DSNICUBC OFFSET0ECA
    ABEND04E RC00E20027 DSNITCU DSNSVBK OFFSET0A02
    Other symptoms are possible depending on the areas being
    overlaid.  Most common is the CUB control blocks which
    are allocated near the SQLDA block.
    

Local fix

  • DROP THE TRIGGER
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users of AFTER TRIGGERS     *
    *                 with a large number of transition            *
    *                 variables.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC00000038 at DSNB1RTR+03B4 or *
    *                      other ABEND symptoms possible.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When an after trigger with a large number of transition
    variables (greater than 500) is executed, the SQLDA may not
    have allocated enough storage. During usage of the SQLDA, DB2
    may write into storage that was not allocated for this structure
    resulting in an overlay.
    

Problem conclusion

  • DB2 has been modified to acquire the proper amount of storage
    for the SQLDA.
    
    Additional keywords: SQLTRIGGER SMCOVERLAY
    

Temporary fix

  • *********
    * HIPER *
    *********
    AM33480
    

Comments

APAR Information

  • APAR number

    PM33480

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-23

  • Closed date

    2011-03-30

  • Last modified date

    2011-05-02

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

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

    UK66506 UK66507 UK66508

Modules/Macros

  • DSNXEXAT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK66506

       UP11/04/21 P F104

  • R810 PSY UK66507

       UP11/04/21 P F104

  • R910 PSY UK66508

       UP11/04/21 P F104

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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 May 2011