Tom, you are correct.  This is the way we do the checkin commands when DR
tapes return because we do a lot of move data commands.  What will happen is
tapes that have no data on them will end up being marked private in the
libvolumes table.  However, it is easy to fix.  All you have to do is an
update libv [library] [volume] status=scratch.  TSM will not mark a tape
scratch for reuse unless it has no data on it.  I have the following select
that I call my "SCRATCH FINDER" that will show you all the volumes that had
the private command issued first or have bad labels and TSM placed the
volumes in private status so it would not try to use them anymore.

select volume_name from libvolumes where status='Private' and
libvolumes.volume_name not in (select volume_name from volumes) and
libvolumes.volume_name not in (select volume_name from volhistory where type
in ('BACKUPFULL', 'BACKUPINCR', 'DBSNAPSHOT', 'EXPORT'))

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Kauffman, Tom [mailto:KauffmanT AT NIBCO DOT COM]
Sent: Thursday, January 16, 2003 4:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Need some help on sequence of "checkin libv ... search" commands


I'm having a senior moment here while trying to revise my TSM server
recovery D/R documentation (we just sprung for a REAL library in the D/R
contract!). (3584 SCSI library)

It's been a l-o-n-g time since I've done this, I need to get the doc revised
this week, and I won't get to test until April.

Two questions:

1)After I do the 'audit library <libname> checklabel=barcode' I need to do
two checkins; I seem to recall that the order is critical, and that I need
to do "checkin libv <libname> search=yes checklabel=barcode status=scratch"
first and then the "checkin libv <libname> search=yes checklabel=barcode
status=private" or I end up with no scratch tapes. But this is memory from
back in the ADSM 3.1 days . . .

2) When I do the database restore (dsmserv restore db dev=lto vol=<volser>
commit=yes) with a library, do I get a prompt to insert the tape in the I/O
station and reply, or do I get told to insert the tape in drive x within y
minutes?

TIA

Tom Kauffman
NIBCO, Inc