Scheduling IBM Z Database Assistant table cleanups

Edit online

You can schedule regular cleanups of your IBM Z Database Assistant data tables.

About this task

Over time, your IBM Z Database Assistant data tables can fill with data. Follow this procedure to remove unneeded data from your tables.
Note: IBM Z Database Assistant provides a default deletion schedule, which varies with data type. For example, the default retention interval for system assessment metrics data is 180 days. This means that system assessment metrics data older than 180 days are automatically deleted by IBM Z Database Assistant. To modify the default deletion schedule, follow the procedure below.
Note: If the clean-up process does not run (for example, if IBM Z Database Assistant has been stopped), unneeded data may accumulate and create a large backlog for the cleanup process. When that happens, once IBM Z Database Assistant is restarted, it limits each daily clean-up to the oldest 24 hours' data, in order to gradually reduce the backlog of data to be cleaned up.
Note: This task requires IBM Z Database Assistant target catalog administrator authority. See User types and roles.

The various categories of data have unique retention intervals, which function to preserve the collected data for the duration of the interval. This means that when a scheduled cleanup runs, the data that fall inside of the retention interval are preserved. To see the tables and retention period for each category, see IBM Z Database Assistant tables that require cleanup.

Procedure

To schedule IBM Z Database Assistant table cleanups:

  1. From the Manage connections page, locate the connection for which you want to schedule table cleanups, and click the Options icon () and select Details.
  2. On the Connection details page, click Schedule management.
  3. Click Cleanup.
  4. On the Cleanup tab, click Schedule cleanup.
  5. In the Schedule cleanup dialog box, specify the following:
    • Daily or weekly - select a frequency for the cleanup. If you select Weekly, you need to specify at least one day per week.
    • Frequency - specify the frequency for daily cleanups.
    • Start date - specify a date for the cleanup to start.
    • End date - specify a date for the cleanup to end.
    • Start time - specify a time for the cleanup to start.
  6. Click Confirm to complete the configuration of system cleanup.
  7. Optional: you can adjust the default retention durations for the various categories of data collected by IBM Z Database Assistant. To adjust the retention interval:
    1. In the Category info table, select the data category or categories to update.
    2. Click Edit.
    3. In the Edit retention days dialog, specify the new value for retention days.
      Note: If you set the retention days to 0, the data is never stored.
    4. Click Confirm to update the value.