PM76303: RESTARTED RUNSTATS CAUSING CATALOG OBJECTS TO GO UTRW

Obtain the fix for this APAR.

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 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.