IBM Support

PI96536: ABEND0C4-0000003B DSNICMT1+0224 IS FOLLOWED BY ABEND0C4-00000038 DSNB1PCK+1E82 ON EVERY CHECKPOINT.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND0C4-0000003B DSNICMT1+0224 is followed by
    ABEND0C4-00000038 DSNB1PCK+1E82 on every checkpoint.
    some value of control blocks were overlaid with 'VSFB'.
    The subsequent recreation also generate dumps of
    ABND=0C4-00000011 DSNB1DCM+0E0A,DSNB1DBP+3AB4,DSNB1PMT+2274 with
    the 'VSFB' overlay issue.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 and 12 for z/OS users of          *
    *                 autonomous stored procedures                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC3B DSNICMT1 OFFSET+0224      *
    *                      may occur when autonomous procedures    *
    *                      is executed and it invokes further      *
    *                      nested routine or trigger.              *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    ABEND0C4 RC3B DSNICMT1 OFFSET+0224 may occur when autonomous
    procedures is invoked. The following abends may also occur:
    ABEND0C4 RC11 DSNB1DCM OFFSET+0E0A
    ABEND0C4 RC11 DSNB1DBP OFFSET+3AB4
    ABEND0C4 RC11 DSNB1PMT OFFSET+2274
    
    When an autonomous procedure invokes another nested routine or
    trigger, and the invoking statement has raised a positive SQL
    condition, Db2 may allocate storage to save the SQL condition in
    the autonomous thread's pool advertently.
    
    This storage is supposed to be allocated in the calling thread's
    pool since it could be reused by this thread later.
    
    The allocation in the incorrect storage pool can cause a storage
    overlay when the autonomous thread de-allocates at the end of
    the autonomous procedure execution and its pool is freed.
    

Problem conclusion

  • Db2 code has been changed to allocate the saved SQL condition
    storage from the calling thread's pool when processing
    autonomous procedure.
    
    Additional Keywords:
    SQLSP SQLSTOREDPROC ABEND0C4
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI96536

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-11

  • Closed date

    2018-07-27

  • Last modified date

    2018-09-04

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

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

    UI57531 UI57532

Modules/Macros

  •    DSNXESTS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI57532

       UP18/08/11 P F808

  • RC10 PSY UI57531

       UP18/08/11 P F808

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.



Document information

More support for: DB2 for z/OS

Software version: 11.0

Reference #: PI96536

Modified date: 04 September 2018


Translate this page: