PM76303: RESTARTED RUNSTATS CAUSING CATALOG OBJECTS TO GO UTRW

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A restarted Runstats job held the catalog objects in UTRW.
    

Local fix

  • Terminate utility and start where if last off.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS users *
    *                 of RUNSTATS SHRLEVEL CHANGE utility          *
    ****************************************************************
    * PROBLEM DESCRIPTION: A restart current of a RUNSTATS         *
    *                      SHRLEVEL CHANGE utility incorrectly set *
    *                      catalog objects (DSNDB06) in UTRW       *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    A RUNSTATS SHRLEVEL CHANGE utility was restarted after
    serialization on a user table space, incorrectly setting
    certain catalog objects in DSNDB06 to a UTRW state.
    
    RUNSTATS includes non-target objects during its serialization
    process but flags these objects as no utility in progress state
    needed.  A logic error in restart processing was causing
    RUNSTATS to set these objects in UTRW.
    
    Affected catalog table spaces in v10:
    DSNDB06.SYSDBASE
    DSNDB06.SYSTSCOL
    DSNDB06.SYSTSIXS
    DSNDB06.SYSTSIPT
    DSNDB06.SYSTSTPT
    DSNDB06.SYSTSTAB
    DSNDB06.SYSTSTSP
    DSNDB06.SYSSTATS
    DSNDB06.SYSTARG
    DSNDB06.SYSHIST
    Affected catalog table spaces in v9:
    DSNDB06.SYSHIST
    

Problem conclusion

  • The RUNSTATS SHRLEVEL CHANGE restart code has been modified to
    not set UTRW for catalog objects.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM76303

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-01

  • Closed date

    2012-12-10

  • Last modified date

    2013-01-02

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

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

    UK90165 UK90166

Modules/Macros

  •    DSNUSDRA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK90165

       UP12/12/27 P F212

  • R910 PSY UK90166

       UP12/12/27 P F212

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:

A10

Reference #:

PM76303

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation