DT_1980
Member
Hi,
Currently every month, we follow below steps manually to Purge data from six Physical files which have key fields (No logical attach to these files) and then use RGZPFM on each file to free up space on disk.
Step 1. Use SQL DELETE commands to delete data from physical files on the basis data selection (Give date range) one at a time.
Step 2. After deleting data from all six files, one at a time, we use RGZPFM command on each of the file to free up space.
QUESTIONS :
1. How can we automate this entire Purging & RGZPFM process ?
2. How can we make this Process run more efficiently ?
Currently, this manual deleting of records and RGZPFM takes 8-10 hrs time (with CPU utilization of around 46 %).
Your help will be appreciated. Thanking you in Advance.
Currently every month, we follow below steps manually to Purge data from six Physical files which have key fields (No logical attach to these files) and then use RGZPFM on each file to free up space on disk.
Step 1. Use SQL DELETE commands to delete data from physical files on the basis data selection (Give date range) one at a time.
Step 2. After deleting data from all six files, one at a time, we use RGZPFM command on each of the file to free up space.
QUESTIONS :
1. How can we automate this entire Purging & RGZPFM process ?
2. How can we make this Process run more efficiently ?
Currently, this manual deleting of records and RGZPFM takes 8-10 hrs time (with CPU utilization of around 46 %).
Your help will be appreciated. Thanking you in Advance.