IBM Support

PI87488: REORG SHRLEVEL CHANGE ABENDS with ABEND0C4 RC38 IN DSNUGLGR.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • REORG SHRLEVEL CHANGE ABENDS with ABEND0C4 RC38 IN DSNUGLGR.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 11 for z/OS and DB2 12 for z/OS                      *
    * users of REORG TABLESPACE SHRLEVEL CHANGE                    *
    * utility                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * REORG TABLESPACE SHRLEVEL CHANGE                             *
    * failed with ABEND0C4 DSNUGLGR                                *
    * OFFSET04DE in LOG phase                                      *
    * processing REDO only update log                              *
    * record                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    User ran a REORG TABLESPACE SHRLEVEL CHANGE against a table
    space defined with 32K page size.  During REORG execution,
    concurrent DML resulted in an update operation where it
    required DB2 to cut a separate UNDO and REDO log record to
    record the before and after record image.  When REORG processed
    this REDO only log record in the LOG phase, it failed with
    ABENDS0C4 in DSNUGLGR + x'04DE'.
    
    The reported problem is caused by a small timing window where
    REORG starts the log apply point in between the generation
    of the split UNDO/REDO update log records.  This resulted in
    REORG processing only the REDO update log record and failed
    with the subject error.
    

Problem conclusion

  • Code has been modified for REORG to correctly process the REDO
    only update log record without abending.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI87488

  • 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

    2017-09-17

  • Closed date

    2017-10-06

  • 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:

    UI50930 UI50931

Modules/Macros

  • DSNUGLGR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI50930

       UP17/10/24 P F710

  • RB10 PSY UI50931

       UP17/10/24 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.

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

Document Information

Modified date:
01 November 2017