PH01720: RECOVER TO POINT IN TIME CAN NOT FIND SYSTEM LEVEL BACKUP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When recovering to a small RBA, RECOVER utility can not find a
  valid system level backup.
  
  DSNU510I NO RECOVERY BASE AVAILABLE FOR RECOVERY OF TABLESPACE
  TEST.TS1
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 non data sharing system users of the         *
  *                 RECOVER utility using system level backup    *
  *                 (SLB) as a recovery base.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The RECOVER utility cannot find system  *
  *                      level backup (SLB) during a recovery to *
  *                      a point in time, and issued             *
  *                      MSGDSNU510I.                            *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  On a non data sharing Db2 system, the customer attempted to run
  RECOVER utility with SLB as a recovery base. The RECOVER failed
  with the DSNU510I message indicating no recovery base available
  for recovery of the table space, even though a SLB was
  available. The recovery was successful but the table space was
  recovered from the logs.
  
  This problem could occur for point in time recovery or for a
  full recovery when the RBA for a non data sharing system is a
  small value. For example, when the RBA value is less than
  than x'00000000004000000000'.
  
  Additional keywords:  TORBA TOLOGPOINT ZS2A
  

Problem conclusion

• Code in the RECOVER utility has been corrected for this
  scenario.
  

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:

  UI59064 UI59066

Modules/Macros

•    DSNUCACR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI59066

     UP18/10/26 P F810

• RC10 PSY UI59064

     UP18/10/26 P F810

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.