PH14753: AFTER PH03896, REPAIR CATALOG ENDS WITH DSNU671I IF THERE IS A LOGICALLY DELETED OBD (DROPPED TABLE) IN THE DBD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The user is using an OEM tool to move a segmented tablespace
  from one subsystem to another; the tool mimics the IBM
  DSN1COPY utility.
  At the end of the procedure a REPAIR CATALOG utility is run
  and it ends with :
  DSNU671I  <DB2I 197 16:38:54.89 DSNUCBVR - DBID=X'01AF'
  PSID=X'002E' OBID=X'004C' TABLE VERSION IS NOT IN THE RANGE
  OF TABLE SPACE VERSION.
  DSNU667I  <DB2I 197 16:38:54.89 DSNUCBVR - REPAIR CANNOT FIX
  THE ERROR.
  .
  REPAIR DBD DIAGNOSE shows:
  DSNU915I  DSNUEDLO - OBD X'004C' E-X'000032AC' R-X'00000000'
          A RECORD-TYPE OBD WHICH HAS BEEN LOGICALLY DELETED
  So the OBD in the REPAIR CATALOG message is for a dropped
  table.
  REPAIR CATALOG checking needs to be be enhanced to skip
  dropped tables in a segmented tablespace.
  

Local fix

• a) restore the PTF for PH03896
  or
  b) repair dbd rebuild
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 users of REPAIR CATALOG on multi-table       *
  *                 table space with one or more dropped         *
  *                 table(s).                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNU671I TABLE VERSION ISERSION IS   *
  *                      NOT IN THE RANGE OF TABLE SPACE         *
  *                      VERSION during REPAIR CATALOG on a      *
  *                      multi-table table space with a dropped  *
  *                      table.                                  *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  The fix for new function APAR PH03896 enhanced REPAIR CATALOG
  to detect tables that are out of the table space version range
  by issuing
  DSNU671I TABLE VERSION IS NOT IN THE RANGE OF TABLE SPACE
           VERSION.
  This message could be issued incorrectly for a dropped table
  when its version is  out of the table space version range.
  

Problem conclusion

• REPAIR CATALOG code is fixed to exclude a dropped table from
  being checked if its version is within the table space version
  range.
  

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:

  UI64700 UI64704

Modules/Macros

•    DSNUCBVR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI64704

     UP19/08/29 P F908

• RC10 PSY UI64700

     UP19/08/27 P F908

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.