Db2 delete job steps
This section describes the steps in the Db2 delete job.
- CLEAN1ST—File Cleanup (IDCAMS)This step ensures that all temporary files used in this job are deleted. This enables you to keep and rerun a JCL stream.
- DLDRV—Delete Driver (XFREXEC)This step ensures that the tables from which data is to be deleted exist. In addition, this step checks user authorization for subsequent steps and separates the extract file into multiple files, one file per table to be deleted.
DELETE—Delete Rows (XFREXEC)This step deletes data from the tables listed on the Delete Confirmation screen.
The DELETE step uses Db2 SQL with all the data that was extracted included in the WHERE clause. File-AID/RDX deletes rows based on exact matches instead of index values.
File-AID/RDX determines the order in which to delete rows such that rows from dependent tables are deleted first. Then, rows from parent tables are deleted. This continues until all rows are either deleted or discarded.
- CLEANLST—File Cleanup (IDCAMS)This step deletes all File-AID/RDX temporary files used in this job. Deleting these files in the last job step enables the job to be restarted in any prior step.
CLEANCTL—File Cleanup (IEFBR14) - OptionalThis step deletes the File-AID/RDX control card PDSEs. Whether step CLEANCTL is commented out or executed is determined by the global job option Delete in-stream data datasets at EOJ. If the job option is set to NO, File-AID/RDX control card PDSEs created in the load and delete jobs will NOT be deleted. Keeping the data sets until all steps run successfully allows for the restarting of the JCL at any step.
- CLEANEXT—File Cleanup (IDCAMS) - Optional
This step deletes the File-AID/RDX EXTPARMS parameter file. Whether step CLEANEXT is commented out or executed is determined by the global job option Delete in-stream data datasets at EOJ. If the job option is set to NO, File-AID/RDX EXTPARMS files created in the load and delete jobs will NOT be deleted. Keeping the data sets until all steps run successfully allows for the restarting of the JCL at any step.