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, IBM Spectrum® Protect 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

Read syntax diagramSkip visual syntax diagramSet 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 IBM Spectrum Protect database.