IBM Support

PM94234: RC00E4010A REPAIR UTILITY SET TABLESPACE PART N PRO

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E4010A RC00C200EA during REPAIR SET TABLESPACE PART
    n PRO when there are outstanding read claims against the
    partition.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of the PRO         *
    *                 (persistent read only) state.                *
    ****************************************************************
    * PROBLEM DESCRIPTION: Two problems are addressed in this      *
    *                      APAR:                                   *
    *                      1. REPAIR utility invocation to set     *
    *                         the PRO state may receive ABEND04E   *
    *                         RC00E4010A.                          *
    *                      2. ALTER TABLE ROTATE PARTITION         *
    *                         succeeds if the partition is in      *
    *                         PRO state (it should fail).          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Two problems addressed by this APAR:
    1. REPAIR SET TABLESPACE PART n PRO may fail with ABEND04E
       RC00E4010A due to a resource unavailable if there is a
       read claim active on the table space.  MsgDSNT500I
       RC00C200EA TYPE 210 is issued to the job output.
    2. ALTER TABLE ROTATE PARTITION succeeds when the partition
       to be rotated is in PRO state.  This should not be allowed
       and the ALTER should fail.
    
    Additional Keywords:
    IDAAV4R1/K
    

Problem conclusion

  • The problems have been addressed as follows:
    1. REPAIR SET TABLESPACE PART n PRO now drains only the writers
       instead of draining writers and readers.  This allows
       the PRO state to be set on even if there are read claims
       active on the table space.
    2. ALTER TABLE ROTATE PARTITION will now fail with SQLCODE-904
       RC00C90635 TYPE 210 if the partition to be rotated is in the
       PRO state.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM94234

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-31

  • Closed date

    2013-09-18

  • Last modified date

    2013-11-04

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

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

    UK97664

Modules/Macros

  • DSNGDART DSNUCBRS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UK97664

       UP13/10/03 P F310

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

Reference #: PM94234

Modified date: 04 November 2013


Translate this page: