Deleting usage data with the Usage Deletion utility

Use the Usage Deletion utility to delete detailed, summarized, and aggregated usage data for a specified period for all systems in the repository. Each time you run the utility, usage data is aggregated to update the asset tables.

To minimize space utilization and improve SQL query performance, keep no more than three months of detailed module usage data and 13 months of aggregated product usage data.

If you do not run the Usage Deletion utility for some time, select a period of a few months, in order to keep the run times down to a reasonable time.

In the previous release, audit records from the TLOGUI table are also deleted by this utility. In the current release, these audit records are no longer deleted by this utility.

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.

Running the Usage Deletion utility

To run the Usage Deletion, use the job HSISUDEL, in the JCLLIB. This job is generated from the HSISCUST post-installation customization job.

TPARAM parameters

COMMIT=: Default is 1000. Number of records stored before issuing of COMMIT.
DSN=: Db2® location. Value assigned, as defined in job HSISCUST.
KEEPDETAIL=: Default is 2. Number of months prior to the current month for which detailed and summarized module usage data are kept. KEEPDETAIL=0 means all detailed and summarized module usage data excluding those from the current month are deleted.
KEEPAGGR=: Default is 12. Number of months prior to the current month for which aggregated product usage data are kept. KEEPAGGR=0 means all aggregated product usage data, excluding those from the current month are deleted.
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.
SID=: System Identifier of system for which usage should be deleted. Specify SID=ALLSIDS to delete usage data for all SIDs.

Note: If KEEPDETAIL is set to a value, then FIRSTDATE / LASTDATE will be ignored. If detailed usage data are to be deleted within a certain date range, then comment out KEEPDETAIL and define dates for FIRSTDATE / LASTDATE. For further details, please see comments described in job HSISUDEL.