Emerson Posadas: backups

¿Quién dijo que TSM solo eran cosas de backups?

Dado que el TSM server es en su núcleo una base de datos de DB2. Se le pueden aventar consultas como a cualquier otra DB:

select count (*) node_name from nodes where DAYS(current_timestamp)-DAYS(LASTACC_TIME)>25
select node_name from nodes where DAYS(current_timestamp)-DAYS(LASTACC_TIME)>25

Et al.

Lo mas básico de lo básico TSM (Tivoli Storage Manager)

# dsmc q fi | more

IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 6, Release 1, Level 5.0
Client date/time: 07/17/13   10:20:53
(c) Copyright by IBM Corporation and other(s) 1990, 2011. All Rights Reserved.

Node Name: DSTN-84YQH9_DST07LP6
Session established with server FOOBAR: AIX
Server Version 6, Release 3, Level 2.0
Server date/time: 07/17/13   10:20:07 Last access: 07/17/13   10:07:32

#     Last Incr Date      Type    File Space Name
---     --------------      ----    ---------------
1   07/16/13   20:59:40   JFS2    /
2   07/16/13   21:00:18   JFS2    /admin

tsm> q ba /db210/dbbackup/*
           Size        Backup Date                Mgmt Class           A/I File
           ----        -----------                ----------           --- ----
         4,096 B 05/25/13   22:46:28      DB_LOG_DISK_MGMT_CLASS      A /foo/foo/
           256 B 05/25/13   07:45:52      DB_LOG_DISK_MGMT_CLASS      A /foo/bar/A
         4,096 B 05/25/13   07:45:52      DB_LOG_DISK_MGMT_CLASS      A /foo/bar/B