PH04023: DB2 UTILITIES - NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function in Db2 Utilities
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the MODIFY                      *
  * RECOVERY utility and FlashCopy image                         *
  * copies.                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PH04023 is the enabling APAR that                            *
  * introduces the new function support                          *
  * for MODIFY RECOVERY FLASHCOPY ONLY.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  A new functionality is added to the MODIFY RECOVERY utility,
  to delete FlashCopy image copy SYSIBM.SYSCOPY records
  if equivalent sequential image copy records exists.
  
  FLASHCOPY ONLY is a new capability to support an efficient
  backup procedure that uses minimal disk space: create a
  FlashCopy image copy virtually instantaneously, create a
  sequential image copy to tape from the FlashCopy image copy,
  and then delete the FlashCopy image copy. To delete this
  FlashCopy image copy, use the MODIFY RECOVERY utility with the
  new FLASHCOPY ONLY option.
  
  The SYSCOPY records for FlashCopy image copies will be deleted
  only if there is a corresponding, equivalent sequential image
  copy data set.
  
  The FlashCopy image copy data sets will be deleted from disk
  if the DELETEDS option is specifed.
  

Problem conclusion

Temporary fix

Comments

• MODIFY RECOVERY FLASHCOPY ONLY is a new option for the
  MODIFY RECOVERY utility. FLASHCOPY ONLY can be used to
  delete SYSIBM.SYSCOPY records for FlashCopy image
  copies if an equivalent sequential image copy exists.
  
  This enabling APAR PH04023 requires two pre-conditioning
  APARs PI96448 and PH03679.
  
  PH04023  introduces the following changes to externals:
  
  MODIFY RECOVERY utility Syntax diagram is updated:
   >>-MODIFY--RECOVERY---------------------------------------->
   . . .
   >--+-DELETE--+------------------+-+---------------+-----+->
  |   |         |-AGE-+-integer-+--+ '-FLASHCOPY-ONLY'     |
      |         |     '-(*)-----'  |                       |
      |         '-DATE-+-integer-+-'                       |
      |                '-(*)-----'                         |
      '-RETAIN----+-LAST--(--integer--)-+---------------+--+
  |               |                     '-FLASHCOPY-ONLY'  |
                  +-LOGLIMIT-------------------------------+
                  '-GDGLIMIT-+---------------------+-------'
                             +-LAST--(--integer--)-+
                             '-LOGLIMIT------------'
   . . .
  
  |FLASHCOPY ONLY
  |Indicates that information for only FlashCopy® image copies
  |are to be deleted. The utility deletes SYSIBM.SYSCOPY
  |records for FlashCopy image copies according to the options
  |that are specified in the DELETE or RETAIN clause.
  
  |SYSCOPY records for a FlashCopy image copy are deleted only
  |if an equivalent sequential image copy exists. An
  |equivalent sequential image copy is a copy that was created
  |from the FlashCopy image copy by the COPY or COPYTOCOPY
  |utility. It has the same START_RBA, PIT_RBA, and DSVOLSER
  |column values in its SYSIBM.SYSCOPY record as the FlashCopy
  |image copy. Records for the FlashCopy image copy are not
  |deleted if uncommitted work was backed out of a FlashCopy
  |image copy with consistency and the equivalent local
  |primary sequential image copy is not cataloged.
  
  |When FLASHCOPY ONLY is specified, MODIFY RECOVERY does not
  |delete SYSIBM.SYSLGRNX records, SYSIBM.SYSOBDS records,
  |update DBD entries and data versions. Additionally, the
  |utility does not insert a SYSIBM.SYSCOPY record with
  |ICTYPE=M and STYPE=R, because the recoverability of the
  |object is not affected.
  
  IBM Knowledge Center is updated for these changes:
  http://www.ibm.com/support/knowledgecenter/SSEPEK
  

APAR Information

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

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

  UI62236

Modules/Macros

• DSNUMDEL DSNUGDDH DSNUGPRT DSNUGUCA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI62236

     UP19/04/16 P F904

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.