Re: Where did my scratch tapes go?

I just look for tapes that have a last use of NULL.

select volume_name from libvolumes where status='Private' and last_use is
NULL

It's normally a small list I get back, then I usually do:

select * from volhistory where volume_name='<volser>'

to see what the last status of each volume is. If the status is Private and
the last volhistory is stgdelete, then you need to figure out whey the tape
is private in the libvolumes....maybe write protected....no labeled....
someone checked it in as private by mistake...?

Bill Boyer
"Some days you are the bug, some days you are the windshield." - ??


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Ben Bullock
Sent: Friday, November 05, 2004 2:11 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Where did my scratch tapes go?


        We've see something similar before. Here's a place to start
looking...

        Run this command to see if you have tapes that are checked in as
"private" volumes, but actually have no client data on them.

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'))

        If you get back a list of tapes, you need to figure out how they
got into that state. Perhaps they are "import" tapes that still have
data on them. Or perhaps it is a procedural issue where your operator is
checking in scratch tapes with the "status=private" flag, in which case
TSM will never use them.

        If you find any tapes to clean up, you could check them out with
the "remove=no" option and then re-check them back in as scratch tapes.

Ben


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Nancy L Backhaus
Sent: Friday, November 05, 2004 12:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Where did my scratch tapes go?


Hello,

Background:
TSM Version 5.2.3.4
AIX Operating System Version 5.2.2.0

2 libraries - one scratch count is steady, my LTOLIB library scratch
count is too low, privates too high.

What is happening?   Where do I begin looking?


11/04/04

STATUS          Unnamed[2]
----------     -----------
Cleaner                  1
Private                350
Scratch                 24

10/04/04

STATUS          Unnamed[2]
----------     -----------
Cleaner                  1
Private                250
Scratch                 59









Nancy Backhaus
Enterprise Systems
Backhaus.Nancy AT HealthNow DOT org
Office: (716) 887-7979
Cell: (716)  609-2138

CONFIDENTIALITY NOTICE: This email message and any attachments are for
the sole use of the intended recipient(s) and may contain proprietary,
confidential, trade secret or privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited and may be a
violation of law.  If you are not the intended recipient or a person
responsible for delivering this message to an intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.