Deleting data from the database
You can delete data from the database using the one of the following keywords of the DSTUTIL command:
- DELUNSTR
- To delete the unstructured data
- DELSTRUC
- To delete the structured data
- DELBOTH
- To delete the structured and unstructured data
It is not possible to code separate cleanup actions for structured and unstructured data because the data store cleanup subtask accepts only one DSTUTIL statement. Therefore, to delete structured and unstructured data with different DSTUTIL statements, use the batch cleanup utility (EQQDSCL batch cleanup sample). The cleanup batch job can run only if the data store is stopped. If you decide to schedule data store cleanup using the EQQDSCL job, set DSTOPTS CINTERVAL(0). For details, see DSTUTIL.
Example:
DSTUTIL DELUNSTR SEARCH1(JBNMLKJOB00*, SYCLEQU) SEARCH2(OLDRMM2) SEARCH3(JBIDEQJOB00467)
This command deletes records that match the following criteria:
JobName LIKE 'JOB00*' and SysClass = 'U' or job OLDER then 2 months or JobId = 'JOB00467'