Deleting obsolete data with the Physical Deletion utility
Use the Physical Deletion utility to delete obsolete data that are no longer required.
Over time, data that have been collected are either superseded or no longer valid, thus taking up space in the repository. Each time, you run this utility, obsolete data for the specified period are physically deleted for all systems in the Repository.
To keep the run time down to a reasonable time, set the date range for a smaller period.
An audit table captures information of this utility when it is run, and these audit records can be browsed using an Analyzer report. As part of housekeeping, obsolete audit records from this utility are deleted by the MDEL Deletion utility, together with audit records from other utilities.
- TLIBRARY
- TLIBSYS
- TMODULE
- TCSECT
- TPOVLIB
- TPRODUCT
- TVENDOR
- TVERSION
Running the Physical Deletion utility
To run the Physical Deletion, use the job HZASPDEL, in the JCLLIB. This job is generated from the HZASCUST post-installation customization job. Refer to comments in the job on how to run an SQL statement to list date ranges for deletion.
TPARAM parameters
- COMMIT=
- Default is 1000. Number of records stored before issuing of COMMIT.
- DSN=
- Db2® location. Value assigned, as defined in job HZASCUST.
- FIRSTDATE=
- Start of the first date range. This is in the form YYYYMM. Only complete months are chosen.
- LASTDATE=
- End of the last date range. This is in the form YYYYMM. Note:The date range of deletion is inclusive of the month specified in the FIRSTDATE and LASTDATE parameters.
- REPSCHEMA=
- Repository qualifier. Name of qualifier is &REPZSCHM.
- RETENTION=
-
Number of months prior to the current month for which libraries marked as deleted are still retained. For example, if RETENTION=12, then only libraries marked as deleted and older than 13 months are physically deleted.
For a setting of RETENTION=0, only libraries marked as deleted for the current month are retained.