3)  Yep... run the infamous SELECT query to find volumeusage for the node
and storage pool you're going to restore (*or* just create a backupset &
restore from it?), empty sufficient slots (use MOVE MEDIA DAYS=nn), then
MOVE MEDIA & CHECKIN the volumes (as PRIvate) before starting the restore.

Consider the following SELECT query, to queue up the right tapes:
select distinct node_name,volume_name,stgpool_name from volumeusage \
where node_name='EXCHMO05_EXC' and stgpool_name='3570TAPEPOOL'


Regards,

Don France

Technical Architect - Unix Engineering/P.A.C.E.
San Jose, CA
mailto:dfrance AT pacbell DOT net
PACE - http://www.pacepros.com
Bus-Ph:   (408) 257-3037


 -----Original Message-----
From:   Anton Gubarkov [mailto:Anton.Gubarkov AT SONY DOT RU]
Sent:   Friday, March 30, 2001 6:20 AM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        dbbackup tapes expiration

Dear colleagues,

my tsm server is eating cartridges for db backup like an elephant. I use
only
full db backups (max db size is estimated to 6GB and I use DLT IV tapes).
Every
time I run dbbackup it picks up a new scratch cart. I have a small library
(IBM
3502-r14 14 slots 2 DLT drives barcode reader) and I wonder how I could make
best use of it for backup purposes.

I also couldn't figure out how to check in the cleaning cart. Every time I
try
to checkin the cart manually I get the error: Library full. When I use
checkin
search=yes the cleaning cart is not seen, although it is seen from library
control panel. And actually why I can't checkin volumes manually?

Suppose I wan to do a massive client restore. (Some fool get a virus and had
his
HDD formatted). I have a lot of volumes in the overflow location. I defined
collocation for DLT storage pool. Can I pre-checkin needed volumes to the
library and then start restore? How?

I hope these are not very big questions for you.

Regards,
Anton Gubarkov.
Tel. +7 095 258 7626
Fax +7 095 258 7650