PH50675: RECOVER UTIL (REDIRECTED RECOVERY) TERMINATES WITH DSNU1566I AND DSNU1567I WHEN THE SOURCE OBJECTS WERE CREATED BEFORE DB2 V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The RECOVER utility (redirected recovery) terminates with
  messages DSNU1566I / DSNU1567I and RC=8 when the source objects
  were created before Db2 V10 and index contains DECIMAL column.
  
  UT statement:  RECOVER TABLESPACE DBTARGET.TSTARGET DSNUM 1
                         FROM DBSOURCE.TSSOURCE DSNUM 1
  
  DSNU1566I DSNUCASV - TARGET INDEXSPACE DBTARGET.IXTARGET DIFFERS
  FROM
                          SOURCE INDEXSPACE DBSOURCE.IXSOURCE
  INDEX SCHEMA MISMATCH
   DSNU1567I DSNUCASV - DEFINITION OF TARGET INDEX
  DBTARGET.IXTARGET DIFFERS FROM
                          SOURCE INDEX DBSOURCE.IXSOURCE: INDEX
  KEY COLUMN 1 SCALE - TARGET: 1, SOURCE: 0
  
  ADDITIONAL SYMPTOMS:
  MSGDSNU1566I
  MSGDSNU1567I
  

Local fix

• BYPASS/CIRCUMVENTION:
  Specify DIAGNOSE TYPE(8107) in the RECOVER job to skip schema
  verification during redirected recovery run.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and Db2 13 for z/OS users of                      *
  * RECOVER utility with the FROM option                         *
  * running on index spaces.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * RECOVER utility with the                                     *
  * FROM option (redirected recovery) on                         *
  * an index space receives warning                              *
  * DSNU1566I and DSNU1567I and RC=8 when                        *
  * the source objects were created                              *
  * before Db2 10 and index contains                             *
  * DECIMAL column.                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  RECOVER utility with the FROM option (redirected recovery) on
  an index space could receive warning message DSNU1566I
  and DSNU1567I and RC=8 when the source objects were created
  before Db2 10 and index contains DECIMAL column. The DECIMAL
  column has a zero value in both the PRECISION and SCALE fields
  in the source table OBD. RECOVER utility schema checking
  falsely identifed this as a schema mismatch between the source
  and target tables.
  

Problem conclusion

• Db2 has been modified to avoid incorrectly issuing messages
  DSNU1566I and DSNU1567I during redirected recovery schema
  checking for an index space if the source objects were
  created before Db2 10 and the precision and scale value for
  a DECIMAL column are both zero in the table OBD.
  

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:

  UI83942 UI83943

Modules/Macros

• DSNISCHV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83942

     UP23/01/14 P F301

• RD10 PSY UI83943

     UP23/01/14 P F301

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.