PI78896: DSNT501I RC00C200EA GOT BY APPLICATIONS DUE TO CLAIMS HELD BY A JOB WITH A LISTDEF AT PART LEVEL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• COPY of a list of PBG tablespaces at partition level that runs
  with OPTIONS EVENT(ITEMERROR,SKIP) keeps the read claim class
  even after the partition has been copied and the next object in
  the list is processed.
  This causes applications to timeout with the following:
  DSNT501I  +DB2P DSNB1DRA RESOURCE UNAVAILABLE
                           REASON 00C200EA
                           TYPE        00000200
  .
  According to the manual , when OPTIONS EVENT(ITEMERROR,SKIP)
  is specified the read claim class is held only while the object
  is being copied.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users of COPY LIST                       *
  * SHRLEVEL CHANGE utility with OPTIONS EVENT                   *
  * (ITEMERROR,SKIP) specified.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SQL mass delete failed with                                  *
  * SQLCODE904 RC00C200EA while                                  *
  * a COPY SHRLEVEL CHANGE                                       *
  * with OPTIONS EVENT(ITEMERROR,SKIP)                           *
  * on a list of table spaces was                                *
  * executing.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  User ran a COPY LIST SHRLEVEL CHANGE with OPTIONS EVENT
  (ITEMERROR,SKIP) on a list of table spaces, where some table
  spaces were partitioned and copied at the partition level with
  the LISTDEF PARTLEVEL option. COPY acquired the part claim
  and table space claim for allocation duration when the copy
  process began on a partitioned object, but held the table space
  level claim even after the copy on that object completed until
  the end of the COPY utility. This caused time outs with
  concurrent SQL (mass delete).
  

Problem conclusion

• When the COPY utility has completed copying all partitions of a
  table space specified in a list, it will release the table
  space level claim.
  

Temporary fix

Comments

APAR Information

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

  PI78535

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

  UI48166

Modules/Macros

• DSNUBADR DSNUBAI2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI48166

     UP17/07/07 P F707

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.