I have seen this problem occasionally.

The sequence that I have seen is:
1) A process requests a scratch tape
2) The tape is mounted in a drive
3) The drive has some type of hardware error
4) The scratch tape being mounted is marked Private so it won't be used for
scratch again
5) Another scratch tape is mounted to satisfy the original request
6) Repeat 2-5 until no more scratch tapes are available.

The result is many tapes in Private status not assigned to any storage pool
and no scratch tapes.

Perhaps this could have been your scenario?

Robert R. Price
ADSM/TSM Administrator
Computer Sciences Corporation
Phone: 412-374-3247
Fax: 412-374-6371
rprice28 AT csc DOT com


----------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------





                      Bill Boyer
                      <bill.boyer              To:      ADSM-L AT VM.MARIST DOT 
EDU
                      @VERIZON.NET>            cc:
                      Sent by: "ADSM:          Subject: Re: Where did my 
scratch tapes go?
                      Dist Stor
                      Manager" <ADSM-L


                      11/05/04 02:17
                      PM
                      Please respond
                      to "ADSM: Dist
                      Stor Manager"






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.