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.

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.