Managing Databases › Time Series Facility Database › How to Customize the Time Series Facility Database › Automate the Reclaim Free Space Process

Automate the Reclaim Free Space Process

The TSF metric database uses large amounts of disk space. When a record is deleted from the TSF database, the space it occupied is reused for the new records. In some instances, the space is never reused if reclaiming is not done. To reclaim free space, we recommend that you run the CHTSDBMT member JCL located in CETJJCL after each metric management execution.

Note: We recommend that you define the CHTSDBMT JCL to an automation product so that it executes automatically when metric management execution ends.

Follow these steps:

1. Edit the CHTSDBMT member of CETJJCL as described in the member.

   CHTSDBMT is ready for execution.

2. Launch your automation product, such as CA OPS/MVS.
3. Define ETJTS601I as a trigger or event message to submit CHTSDBMT. Complete this step using your site-specific practices.

   CHTSDBMT is executed each time message ETJTS601I is received. This JCL submits an online reorganization of the metric data area and defrags the index area of the TSF database.

You have customized the TSF database to optimize database space performance and to reclaim free space after each metric management execution.