I have the following script defined in TSM. All I have to do, is: run
q_n_scratch
(or just click on the script I want to run, from the Web GUI)
/* -----------------------------------------*/
/* Script Name: Q_N_SCRATCH */
/* Description: Display number of scratch */
/* for each libraries defined */
/* Parameter: none */
/* Example: run q_n_scratch */
/* -----------------------------------------*/
select LIBRARY_NAME, count(*) as -
"Number of Scratch" from libvolumes where -
status='Scratch' group by LIBRARY_NAME
Serge Gaudet, CMI
Consultant
"Tyree,
David" To: [EMAIL PROTECTED]
<david.tyree@ cc:
SGMC.ORG> Subject: Several tapes with zero capacity
and zero
Sent by: utilization
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>
18/10/2000
10:09 AM
Please
respond to
"ADSM: Dist
Stor Manager"
I'm new with the ADSM system, so I hope I don't sound to dumb here!
I've been looking at the list for a couple of months and I've gotten a lot
of good information from it so far.
Here we go, I run a select command every few days to check on the
number of reclaimable tapes we have in the system. When I get several tapes
with a PCT_RECLAIM above 70-80% I run the reclamation process. We do the
tape reclamation manually. Here is the select command we use:
select volume_name,est_capacity_mb,pct_utilized,pct_reclaim from
volumes where stgpool_name='COPYPOOL' order by pct_reclaim desc
The following is part of the result I get:
VOLUME_NAME EST_CAPACITY_MB PCT_UTILIZED
PCT_RECLAIM
SG0113 19317.5 95.9
4.1
SG0117 14658.0 97.1
2.8
SG0007 0.0 0.0
0.0<---------------??
SG0009 0.0 0.0
0.0<---------------??
SG0014 0.0 0.0
0.0<----------------??
SG0027 0.0 0.0
0.0<----------------??
SG0030 13671.7 99.9
0.0
SG0046 0.0 0.0
0.0<-----------------??
SG0047 13533.1 100.0
0.0
SG0075 0.0 0.0
0.0<----------------??
SG0108 0.0
0.0 0.0<----------------??
SG0124 0.0 0.0
0.0<-----------------??
SG0133 0.0 0.0
0.0<----------------??
SG0135 11764.2 100.0
0.0
SG0139 10122.4 100.0
0.0
How can I have a tapes with 0 capacity and 0 utilization?
We use 3590 tapes in a 3494 library attached to an IBM Netfinity
server running NT 4 using ADSM version 3.7.3.
Any ideas?
David Tyree
Microcomputer Specialist
South Georgia Medical Center
912.333.1155
