A fix is available
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 number
PH27268
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-07-08
Closed date
2021-01-06
Last modified date
2021-02-01
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"12.0"}]
Document Information
Modified date:
02 February 2021