PH42726: RECOVER UTIL (REDIRECTED RECOVERY) TERMINATES WITH DSNU1566I ANDDSNU1567I 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:
  
  UT statement:  RECOVER TABLESPACE DBTARGET.TSTARGET DSNUM 1
                         FROM DBSOURCE.TSSOURCE DSNUM 1
  
  DSNU1566I DSNUCASV - TARGET TABLESPACE DBTARGET.TSTARGET DIFFERS
            FROM SOURCE TABLESPACE DBSOURCE.TSSOURCE DSNUM 1 TABLE
            SCHEMA MISMATCH
  DSNU1567I DSNUCASV - DEFINITION OF TARGET TABLE TTT.TBTARGET
            DIFFERS FROM SOURCE TABLE SSS.TBSOURCE : TABLE COLUMN
            5 DEFAULT MISMATCH
  
  This error has its source in OBDREC changes for nullable columns
  introduced in Db2 V10.
  
  ADDITIONAL SYMPTOMS:
  MSGDSNU1566I
  MSGDSNU1567I
  

Local fix

• BYPASS/CIRCUMVENTION:
  1) Specify DIAGNOSE TYPE(8106) or DIAGNOSE TYPE(8107) in the
     RECOVER job to skip schema verification during redirected
     recovery run.
      or
  2) Run REPAIR DBD REBUILD to refresh the OBDREC with the most
     current setting.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the RECOVER                     *
  * utility with the FROM keyword specified.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The RECOVER utility with the FROM                            *
  * keyword specified(redirected recovery)                       *
  * terminates with messages                                     *
  * DSNU1566I / DSNU1567I                                        *
  * 'DEFINITION OF TARGET TABLE xx.xxx                           *
  *   DIFFERS FROM SOURCE TABLE xx.xxx :                         *
  *   TABLE COLUMN x DEFAULT MISMATCH'                           *
  * and rc = 8, when both source and                             *
  * target objects definitions match. Only                       *
  * affects source objects prior to v10.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Prior to version 10, columns defined as default null used a
  different value in the OBDREC control block to indicate default
  null. When the old OBDREC value was compared, schema checking
  falsely identifed this as a schema mismatch between the source
  and target tables. This resulted in the recover utility
  terminating with the DSNU1566I and DSNU1567I message.
  

Problem conclusion

• DB2 has been modified to no longer incorrectly fail the
  RECOVER utility with rc=8 and report DSNU1566I / DSNU1567I
  messages on source objects prior to version 10.
  

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:

  UI79569 PH47865

Modules/Macros

• DSNISCHV DSNIPPHO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI79569

     UP22/03/11 P F203

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.