Volume history stuff...

Volume History

Number of full tsm db backups in the last XX hours

tsm: SERVER1> SELECT COUNT(*) FROM volhistory WHERE -

type='BACKUPFULL' AND date_time>=current_timestamp-24 hours

Unnamed[1]

-----------

1

Number of full or incremental tsm db backups in the last XX hours

tsm: SERVER1> SELECT COUNT(*) FROM volhistory WHERE ( type='BACKUPFULL' OR type='BACKUPINCR' ) -

AND date_time>=current_timestamp-24 hours

Unnamed[1]

-----------

2

Information about full and incremental tsm db backups in the last XX hours

tsm: SERVER1> SELECT * FROM volhistory WHERE ( type='BACKUPFULL' OR type='BACKUPINCR' ) -

AND date_time>=current_timestamp-24 hours

DATE_TIME: 2008-03-04 06:30:35.000000

UNIQUE: 0

TYPE: BACKUPFULL

BACKUP_SERIES: 289

BACKUP_OPERATION: 0

VOLUME_SEQ: 1

DEVCLASS: 3584

VOLUME_NAME: B05416

LOCATION:

COMMAND: