IBM Support

PH30692: POINT-IN-TIME RECOVER ABENDS S04E RC00E20027 DUE TO OVERLAY.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Point-in-time recover abends S04E RC00E20027, when recover
    utility scans 2 ICTYPE W STYPE A record tablespace in SYSCOPY.
    
     1. create 4 parts table
     2. create partlevel copy for part 1
     3. set part 3 to REORGP
     reorg part 3 to generate 1st ICTYPE W STYPE A
     4. set part 3 to REORGP again
     reorg part 3 to generate 2nd ICTYPE W STYPE A
     5. recover DSNUM 1 tolastcopy gets 00E20027.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of the RECOVER                     *
    * utility to a point in time (PIT) at the                      *
    * partition level.                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * RECOVER to a PIT at partition level                          *
    * receives ABEND04E RC00E20027 in                              *
    * DSNSVBK OFFSET3246.                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    ABENDS04E RC00E20027 in DSNSVBK +x'3246' was received during
    execution of the RECOVER TABLESPACE utility at partition level
    with TOCOPY option. The following is an example that can result
    in the ABEND:
        RECOVER TABLESPACE TESTDB.TESTTS DSNUM  1 TOCOPY
    The ABEND04E occurred because 4 bytes in the storage area
    were overlaid. The storage overlay can occur when the recovery
    point is prior to multiple REORG TABLESPACE utility executions
    which materialized the alteration of partition limit keys. The
    SYSIBM.SYSCOPY records for the REORG TABLESPACE executions
    (ICTYPE W STYPE A) had the same LOWDSNUM and HIGHDSNUM column
    values like this:
       +-----------------------------------------------+
       | DSNUM | ICTYPE | STYPE | LOWDSNUM | HIGHDSNUM |
       +-----------------------------------------------+
       |     3 | W      | A     |        3 |         3 |
       |     3 | W      | A     |        3 |         3 |
       +-----------------------------------------------+
    These types of SYSCOPY records can be inserted by:
      - REORG TABLESPACE with the REBALANCE option.
      - ALTER of partition limit key(s) followed by REORG
        TABLESPACE on a partition range.
    Additional keywords: TOLOGPOINT TORBA TOLASTFULLCOPY TOLASTCOPY
                         LISTDEF PARTLEVEL DB2OVRLAY/K
    

Problem conclusion

  • The RECOVER utility has been modified to fix the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH30692

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-21

  • Closed date

    2020-12-30

  • Last modified date

    2021-02-01

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

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

    UI73318

Modules/Macros

  • DSNUCASA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI73318

       UP21/01/08 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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"12.0"}]

Document Information

Modified date:
02 February 2021