Useful stats...

Summary

Summary of archive operations in the last 7 days

tsm: SERVER1> select cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) -

as "Archive data in GB" from summary where -

activity='ARCHIVE' and end_time>timestamp(current_date)-(7)days

Archive data in GB

--------------------

14508.09

Summary of backup operations in a specific range

tsm: SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) -

AS "Backed up data in GB" FROm summary WHERE activity='ARCHIVE' -

AND start_time >{ts '2007-06-01 00:00:00'} AND start_time <{ts '2007-07-01 00:00:00'}

Backed up data in GB

--------------------

38829.70

Statistics of archive, backup, restore and retrieve operations per node in the last 7 days (GB)

tsm: SERVER1> SELECT entity, activity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) -

FROM summary WHERE end_time>current_timestamp-(7)DAY and ( activity='ARCHIVE' OR -

activity='BACKUP' OR activity='RESTORE' OR activity='RETRIEVE' ) GROUP BY entity, activity

ENTITY ACTIVITY Unnamed[3]

------------------ ------------------ ----------

SERVER-01 ARCHIVE 81.14

SERVER-01 BACKUP 261.68

SERVER-01 RESTORE 2.91

SERVER-02 ARCHIVE 171.51

SERVER-02 BACKUP 0.00

SERVER-03 ARCHIVE 17.64

SERVER-04 ARCHIVE 168.32

SERVER-04 BACKUP 530.77

...