Or you could redirect (append) a scheduled select after the days backup to compare
growth over time:
select stgpool_name,count(*) from volumes group by
stgpool_name
[EMAIL PROTECTED] 10/18/00 08:40AM
# of tapes used for backups on a daily basis.
The simplest way is to do daily queries of your backup storage pool
volumes complement, and track the increase.
Or you could look in the actlog for msgs 1340,1341,1360,6684...
Or at the tail of your volhistory disk file:
unix tail dsmserv.volhistory
2000/10/17 15:48:42 STGDELETE 0 0 0 MAGSTAR3590
M00569
2000/10/17 16:30:33 STGDELETE 0 0 0 MAGSTAR3590
M00724
2000/10/17 17:04:37 STGDELETE 0 0 0 MAGSTAR3590
M00833
2000/10/17 17:39:14 STGNEW 0 0 0 MAGSTAR3590
M02030
2000/10/17 17:45:36 STGDELETE 0 0 0 MAGSTAR3590
M01467
2000/10/17 18:16:50 STGDELETE 0 0 0 MAGSTAR3590
M01175
2000/10/17 18:47:06 STGDELETE 0 0 0 MAGSTAR3590
M00468
2000/10/17 20:23:20 STGDELETE 0 0 0 MAGSTAR3590
A3
2000/10/17 20:53:12 STGDELETE 0 0 0 MAGSTAR3590
M00060
2000/10/18 00:11:36 STGNEW 0 0 0 MAGSTAR3590
M02031
ADSMq actlog begind=-1 msg=1340
Date/TimeMessage
--
10/17/00 09:02:15 ANR1340I Scratch volume M02025 is now
defined in storage
pool TSMDBB.
10/17/00 10:32:35 ANR1340I Scratch volume M02026 is now
defined in storage
pool BACKUP3590_OFFSITE.
10/17/00 11:31:02 ANR1340I Scratch volume M02027 is now
defined in storage
pool BACKUP3590_OFFSITE.
10/17/00 13:42:07 ANR1340I Scratch volume M02028 is now
defined in storage
pool BACKUP3590_OFFSITE.
10/17/00 15:20:02 ANR1340I Scratch volume M02029 is now
defined in storage
pool TAPEPOOL.
10/17/00 17:39:17 ANR1340I Scratch volume M02030 is now
defined in storage
pool TAPEPOOL.
10/18/00 00:11:40 ANR1340I Scratch volume M02031 is now
defined in storage
pool TAPEPOOL.
tsm: ADSMq actlog begind=-1 msg=1360
Date/TimeMessage
--
10/18/00 05:01:16 ANR1360I Output volume M02032 opened
(sequence number 1).
tsm: ADSMq actlog begind=-1 msg=1341
Date/TimeMessage
--
10/17/00 15:03:06 ANR1341I Scratch volume M00031 has been deleted from
storage pool BACKUP3590_OFFSITE.
10/17/00 15:03:09 ANR1341I Scratch volume M00042 has been deleted from
storage pool BACKUP3590_OFFSITE.
10/17/00 15:48:45 ANR1341I Scratch volume M00569 has been deleted from
storage pool TAPEPOOL.
sm: ADSMq actlog begind=-1 msg=6684
Date/TimeMessage
--
10/17/00 15:03:07 ANR6684I MOVE DRMEDIA: Volume M00031 was deleted.
10/17/00 15:03:09 ANR6684I MOVE DRMEDIA: Volume M00042 was deleted.
10/17/00 15:03:11 ANR6684I MOVE DRMEDIA: Volume M00092 was deleted.
--
Richard
