Monitored Records Maintenance

The Monitored Records Maintenance option provides information about the records of report requests and allows you to delete redundant or unrepresentative request records to keep the Usage Monitoring databases to an efficient size.

How to: Review Data Only or Review Data Before Deleting Define Deletion Criteria Example: Generating a Number of Monitor Records Report Generating a Monitor Record Detail Report Generating a Custom Report

You can delete data from the system tables, the Usage Monitoring databases, or both. This feature also includes a review option to let you see monitored data in report form and preview the potential results of deletion criteria. In addition, when databases change significantly, you can use the Monitored Records Maintenance option to delete records collected before the change.

Select the Monitored records maintenance option in the Database control menu and press Enter. The following screen opens:

The following options are available:

• Reviewing monitor data first and then defining deletion criteria.
• Defining deletion criteria without reviewing monitor data.
• Reviewing monitor data only.

The following sections describe these options.

Procedure: How to Review Data Only or Review Data Before Deleting

1. Select Monitored Records Maintenance from the Database Control menu.

2. When you select either the Review monitor data and define deletion criteria option or the Review monitor data only option from the Monitored Records Maintenance menu, the following screen opens:

3. Select one of the following types of reports:
   • Number of monitored records. Select the Userid, Database name, or Request name field to see all entries for that field as well as the number of records for each.
   • Monitored record detail. Select the Userid, Database name, or Request name field to see a detailed report for all records, sorted by that field.
   • Custom. Enter a specific Userid, Database name, and Request name to see a detailed report for all records that match your criteria.

4. At the bottom of the menu is an Offline option. Select it to send the information to a printer in addition to displaying it on the screen.

5. If you selected the option to Review monitor data and define deletion criteria, once you finish reviewing data, a screen that lets you define deletion criteria displays.

The following examples use sample data to show reports for reviewing data before you decide what to delete.

Example: Generating a Number of Monitor Records Report

The following is a sample report that results when you select the Number of monitor records per userid option:

This report displays the field you specified, in this case, userid, sorted, and the number of records for each entry.

Example: Generating a Monitor Record Detail Report

The following is a sample report when you select the Monitor record detail sorted by userid option:

This report shows a number of request details for all records, sorted by the Userid field.

Example: Generating a Custom Report

When you select Custom report from the menu, the following screen is displayed allowing you to specify the information you want to include in the report:

The report generated from this screen shows all the same columns as the detail report in the previous example, but only for the criteria you specify. You can provide values for the date fields, and you can provide values for Userid, Data name, Source, and Request name. If you do not provide values for any of these four selection fields, you must provide values for the date fields.

Once you have entered your specifications, press the Enter key to review a report that matches all your criteria. Press PF4 to bypass the Custom report and return to the Usage Monitor database maintenance menu or PF3 to return to the Database Control menu.

The following report would be generated if you entered the Request name CAR01 in the Custom Report Options menu:

Procedure: How to Define Deletion Criteria

Perform the following steps to define deletion criteria for your records.

Note: Before you define any deletion criteria, it is recommended that you first review the data. For more information, see How to Review Data Only or Review Data Before Deleting.

1. If you are not first reviewing data, select Monitored records maintenance option from the Database Control menu. The following screen opens:

2. Select Define deletion criteria only from the Usage Monitor Database Maintenance menu. The following screen opens:

The options in this menu enable you to specify deletion criteria.

3. Using any combination of values, type the Userid, Database name, Source, Request name, or Dates for the records you want to delete.

4. Press the Enter key to delete or PF3 to return to the Usage Monitoring menu.

SmartMode does not immediately delete any records. Instead, it displays the following screen, which shows the deletion criteria specified and allows you to confirm the delete:

5. To change the criteria, press PF6 to return to the previous screen. Press PF3 to return to the Database Control menu without performing the delete. To proceed with the deletion, press the Enter key.

SmartMode immediately deletes all records that meet the specified criteria without displaying them first. As a result, it is recommended to review the information thoroughly before you delete.