Db2 Tools

 View Only

CA Merge/Modify: 3 Recent Enhancements - DSNUM PART, Wildcarding and OR-DSNOTFOUND 

Jan 03, 2018 05:42 AM

This article summarizes 3 features recently added to CA Merge/Modify for Db2 for z/OS.

DSNUM PART to support deletion of entries from SYSCOPY

Validity of DSNUM - The DSNUM keyword is valid in the following cases:

  • Single tablespace - DSNUM keyword is allowed and deletes all records for the copy data set and partition as if DSNUM ALL has been specified.
  • For partitioned objects, deletes all records for the copy data set and partition, but leaves records for inline copies intact.
  • LISTDEF, OLM - DSNUM keyword will be rejected with an error message
  • Wildcarding - DSNUM ALL and DSNUM PART are only allowed.

Behavior of values specified for DSNUM

  • n - Process SYSCOPY records with DSNUM n (no change of behavior)
  • ALL - Process SYSCOPY records with any DSNUM (no change of behavior)
  • PART - Process SYSCOPY records with DSNUM<>0 for partitioned tablespaces. And SYSCOPY records with any DSNUM for non-partitioned tablespaces.

Note: DSNUM PART is only valid with the MODIFY RECOVERY control statement DELETE DATE, DELETE AGE, or DELETE KEEP options when wildcard characters are used.

Wildcarding

Allows to specify wildcarding characters in the TABLESPACE name to process multiple objects with simple syntax. Interruption for running transactions is minimum (commit as often as possible - for each database object).

Syntax example for processing a database:

MODIFY RECOVERY TABLESPACE DB0PDBA0.%

If wildcarding characters are detected, then

  • Detect %.%. This wildcard is prohibited - Error message.
  • Wildcarding will not include catalog and directory objects.
  • Apply the same limitations as when LISTDEF or OLIST are specified.
  • Allow to specify OR-DSNOTFOUND - this will in addition delete all SYSCOPY records whose datasets do not exist.

OR-DSNOTFOUND keyword

Deletes rows from SYSIBM.SYSCOPY that reference cataloged image copy data sets that do not exist. The OR-DSNOTFOUND option does not affect SYSLGRNX staging or deletion.
We will allow to combine OR-DSNOTFOUND with DELETE AGE(22) 
This example deletes the image copy rows where the cataloged image copies are not found in the ICF catalog.

MODIFY RECOVERY TABLESPACE DALPHA.% DELETE AGE(22) OR-DSNOTFOUND

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.