PM77280: SERVICEABILITY APAR TO ADDRESS DBET INCONSISTENCIES

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SERVICEABILITY APAR NEEDED TO TROUBLE SHOOT DBET INCONSISTENCIES
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users of BACKUP SYSTEM and  *
    *                 RESTORE SYSTEM in environments that perform  *
    *                 ALTER TABLE ADD PARTITION                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIDBPL ERQUAL50CC *
    *                      or                                      *
    *                      ABEND04E RC00C90101 DSNIDBAB ERQUAL500A *
    *                      during RESTORE SYSTEM when the activity *
    *                      being log-applied includes ALTER TABLE  *
    *                      ADD PARTITION                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The aforementioned abends during RESTORE SYSTEM indicate that
    the caller of DBET is trying to turn on an exception state on a
    partition that is higher than what DBET's internal structure is
    aware of. For example, the caller is trying to turn on RBDP on
    index partition 4 but DBET's structure shows that the index only
    has 3 partitions.
    
    Investigation showed that during mainline when the ALTER TABLE
    ADD PARTITION statement was executed, DBET had no update to do
    because the object of interest had no pending or restrictive
    states at the time (no entry in DBET).
    
    Then during RESTORE SYSTEM, the object was added to DBET with X
    number of partitions, as result of RESTORE SYSTEM's function,
    not as result of applying a log record. Then RESTORE SYSTEM
    proceeded through the ALTER TABLE ADD PARTITION portion of the
    log apply, however this by design did not invoke DBET to update
    the number of partitions, given that in the mainline when the
    ALTER TABLE ADD PARTITION statement took place, DBET had no
    exception states for the object and hence no log record for the
    ALTER.
    
    So now in RESTORE SYSTEM when DBET was subsequently called to
    turn on an exception state for partition X+1, DBET abended given
    that it was out of synch with other DB2 components regarding the
    number of partitions.
    

Problem conclusion

  • DB2 has been modified to write a diagnostic log record when
    ALTER TABLE ADD PARTITION is executed, which will be written if
    the object does not have any exception states - meaning if the
    object is not in DBET.
    
    During RESTORE SYSTEM, this log record will be applied so that
    the the DBET structure is up to date with regard to the current
    number of partitions for the object.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77280

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-16

  • Closed date

    2013-07-26

  • Last modified date

    2013-09-03

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

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

    UK96169 UK96172

Modules/Macros

  • DSNGDADP DSNGDAPT DSNGDART DSNIDBAB DSNIDBLG DSNIIEPL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96169

       UP13/08/14 P F308

  • R910 PSY UK96172

       UP13/08/14 P F308

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM77280

Modified date:

2013-09-03

Translate my page

Machine Translation

Content navigation