PH27268: REDIRECTED RECOVERY ISSUES MSGDSNU1574I

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Redirected recovery, the RECOVER utility with the FROM option
  issues message :
  
  DSNU1574I - TRANSLATE ERROR ON TABLESPACE db.ts
              RETURN CODE X'8' REASON CODE X'D4E2D7D6'
  
  and the RECOVER ends with RC04
  
  Additional keywords: ABEND04E 00C90110 in DSNIDILS 501B
                       ERQUAL501B
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of RECOVER                         *
  * utility with the FROM option.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Prior to this APAR, RECOVER with the                         *
  * FROM option (redirected recovery) on                         *
  * a target UTS that contains a table                           *
  * with many columns along with one                             *
  * or more LOB and/or XML columns, could                        *
  * receive warning message MSGDSNU1574I                         *
  * with reason code X'D4E2D7D6' during                          *
  * the TRANSLAT phase.                                          *
  *   Subsequent SQL DELETE on rows in                           *
  * the target table may receive                                 *
  * ABEND04E RC00C90110 in DSNIDILS                              *
  * ERQUAL501B.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During redirected recovery on a target table space (UTS)
  that contains a table with many columns along with one or more
  LOB and/or XML columns, this warning message was issued in the
  TRANSLAT phase:
      DSNU1574I ERROR DURING TRANSLATE ON TABLESPACE db.ts
                RETURN CODE X'00000008' REASON CODE X'D4E2D7D6'
  The RECOVER completed successfully with RC4. This warning
  message and reason code indicates auxiliary OBIDs for LOB
  and/or XML columns were detected in multiple system pages in
  the target table space.
    Subsequent SQL DELETEs of rows in the target table could
  receive ABEND04E RC00C90110 in DSNIDILS:501B.  SQL SELECTs
  and UPDATEs are successful and are not affected.
    Additional keywords:  RC04 RCD4E2D7D6 ERQUAL501B
  

Problem conclusion

Temporary fix

Comments

•   In the scenario above, additional functionality has been
  added to support auxiliary OBIDs for LOB and/or XML columns
  in system pages of the target table space when there is more
  than one system page.  Redirected recovery will no longer
  issue the DSNU1574I message for this scenario.  The abend
  during SQL DELETE after a redirected recovery will no longer
  occur.
  

APAR Information

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

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

  UI73358

Modules/Macros

• DSNISCHV DSNIROBD DSNINTRA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI73358

     UP21/01/15 P F101

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.