IBM Tivoli Storage Manager, Version 7.1

SET SUMMARYRETENTION (Set number of 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, issue 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, Tivoli® Storage Manager 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.

Example: Specify the number of days to keep information in the SQL activity summary table

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

set summaryretention 15

Related commands

Table 1. Commands related to SET SUMMARYRETENTION
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 Tivoli Storage Manager database.

Feedback