Administrator's Reference

SET SUMMARYRETENTION (Set Days to Keep Data in Activity Summary Table)

Use this command to specify the number of days to keep information in the SQL activity summary table.

The SQL activity summary table contains statistics about each client session and server processes. For a description of the information in the SQL activity summary table, use the following command:

select colname,remarks from columns, where tabname='SUMMARY'

Issue the QUERY STATUS command to display the number of days the information is kept. At installation, TSM allows each server to determine its own number of days for keeping information in the SQL activity summary table.

Privilege Class

To issue this command, you must have system privilege.

Syntax

>>-Set SUMmaryretention--+------+------------------------------><
                         '-days-'
 

Parameters

days
Specifies the number of days to keep information in the activity summary table. You can specify a number from 0 to 9999. A value of 0 means that information in the activity summary table is not kept. A value of 1 specifies to keep the activity summary table for the current day.

Examples

Task

Set the server to retain the activity summary table information for 15 days.

Command:
set summaryretention 15

Related Commands

Table 266. Commands Related to SET RETRYPERIOD

Command Description
QUERY STATUS Displays the settings of server parameters, such as those selected by the SET commands.
SET ACTLOGRETENTION Specifies the number of days to retain log records in the activity log.
QUERY ACTLOG Displays messages from the server activity log.
SELECT Allows customized queries of the TSM database.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]