DELOLDDS control statement

Specifies whether to delete old input database data sets and secondary index data sets after successful reorganization.

This control statement is optional. The default is DELOLDDS=NO.

Read syntax diagramSkip visual syntax diagramDELOLDDS=NOYES
YES
When name swapping and DBRC notification complete successfully, the old input database data sets are deleted. If you also specify INDEXBLD=YES,NEW or PSINDEXBLD=YES,NEW, the old secondary index data sets are also deleted.
  • If DELOLDDS=YES is specified for a HALDB partition that is not online reorganization capable, the old input database data sets are deleted.
  • If DELOLDDS=YES is specified for an online reorganization capable HALDB partition whose A-through-J and X data sets were active before parallel reorganization, old input A-through-J and X data sets are deleted.
  • If DELOLDDS=YES is specified for an online reorganization capable HALDB partition whose M-through-V and Y data sets were active before parallel reorganization, both the old input M-through-V and Y data sets and the old A-through-J and X data sets, if they exist, are deleted.

DELOLDDS=YES is effective only when NAMESWAP=YES is specified.

NO
No old data sets are deleted.

If DISPOLDDS control statement is specified, the DELOLDDS control statement is not allowed.