IBM Tivoli Storage Manager, Version 7.1

Querying the SQL activity summary table

You can query the SQL activity summary table to view statistics about client operations and server processes.

About this task

Some of the client operations recorded to the table are BACKUP, RESTORE, ARCHIVE and RETRIEVE. Server processes include MIGRATION, RECLAMATION and EXPIRATION.

To list column names and their descriptions from the activity summary table, enter the following command:

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

Here are a few example queries of the activity summary table.

To display all events starting at 00:00 a.m. of the current day until the present time, enter:

select * from summary

The result might look like this:

      START_TIME: 2008-10-10 10:48:52.000000
        END_TIME: 2008-10-10 10:48:56.000000
        ACTIVITY: BACKUP
          NUMBER: 10
          ENTITY: NODE1
        COMMMETH: Tcp/Ip
         ADDRESS: ibm-164391ac47a.tucson.ibm.com:2515
   SCHEDULE_NAME:
        EXAMINED: 3
        AFFECTED: 3
          FAILED: 0
           BYTES: 36631067
            IDLE: 0
          MEDIAW: 0
       PROCESSES: 2
      SUCCESSFUL: YES
     VOLUME_NAME:
      DRIVE_NAME:
    LIBRARY_NAME:
        LAST_USE:
       COMM_WAIT: 2
NUM_OFFSITE_VOLS: 

ANS8002I Highest return code was 0.

To display all events starting at or after 00:00 a.m. on October 10, 2008 until the present time, enter:
```
select * from summary where start_time>='2008-10-10 00:00:00' 
```

You can determine how long to keep information in the summary table. For example, to keep the information for 5 days, enter the following command:

set summaryretention 5

To keep no information in the table, specify a value of 0.

Tivoli® Storage Manager does not create records in the SQL activity summary table for manual backups or for successful scheduled backups of 0 bytes. Records are created in the summary table for successful scheduled backups only if data is backed up.

Feedback