Re: Several tapes with zero capacity and zero utilization
Knowing how many scratches you have is always a problem, particularly if you have scratches outside the library. This has always seemed a TSM "hole" to me - I was brought up using TMS/UCC1/CA1 on mainframes. Is there anyone knowledgeable as to why TSM doesn't implement a scratch-pool philosophy? It really bugs me that an ADSM tape might be a DBbackup, node export or scratch and a q vol will return a "not known" error code. Steve Harris AIX/ADSM/Oracle/HACMP Guy The Wesley Hospital, Brisbane Australia "Tyree, David" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 19/10/2000 01:19:12 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Fax to: Subject: Re: Several tapes with zero capacity and zero utilization That sounds like an excellent idea. At the moment we are running short on tapes until we get a new batch in. Do you know of an _easy_ way to tell just how many scratch tapes we have? We are using select statements using the info in the volumes table. The problem is the tapes only show in stgpool_name as either copypool or tapepool. I run a select statement to get the number of copypool tapes then another to get the number of tapepool tapes. Then I have to add then together and subtract that from the number of tapes we put in the library to begin with. It's a convoluted process but that's the best I can come up right now. I can't find a direct way to tell me the number of scratch tapes I have. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 10:44 AM To: [EMAIL PROTECTED] Subject: Re: Several tapes with zero capacity and zero utilization >When I get several tapes with a PCT_RECLAIM above 70-80% >I run the reclamation process. David - Another approach to scratch pool management is to wait until the number of scratches reaches a comfortable minimum, and only then start reclamation. I prefer to let attrition empty tapes as much as possible, rather than subject tapes to wear in copying remaining contents sooner than necessary - considering also that that remainder may expire soon anyway, making that much copying wasteful. >How can I have a tapes with 0 capacity and 0 utilization? What your display doesn't tell you is the state of the tapes. Particularly for a copy storage pool, REUsedelay should be in effect, and the volumes would thus be Pending. Richard Sims, BU === This email message has been swept by MIMESweeper at The Wesley Hospital - Australia Although this email has been scanned for Viruses please ensure that due care is taken and correct virus management procedures are maintained. ===
Re: Several tapes with zero capacity and zero utilization
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] 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.595.9 4.1 SG0117 14658.097.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.799.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
Re: Several tapes with zero capacity and zero utilization
For scratches in our library this works: SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS FROM LIBVOLUMES WHERE LIBVOLUMES.STATUS="Scratch" >>> [EMAIL PROTECTED] 10/18/00 11:19AM >>> That sounds like an excellent idea. At the moment we are running short on tapes until we get a new batch in. Do you know of an _easy_ way to tell just how many scratch tapes we have? We are using select statements using the info in the volumes table. The problem is the tapes only show in stgpool_name as either copypool or tapepool. I run a select statement to get the number of copypool tapes then another to get the number of tapepool tapes. Then I have to add then together and subtract that from the number of tapes we put in the library to begin with. It's a convoluted process but that's the best I can come up right now. I can't find a direct way to tell me the number of scratch tapes I have. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 10:44 AM To: [EMAIL PROTECTED] Subject: Re: Several tapes with zero capacity and zero utilization >When I get several tapes with a PCT_RECLAIM above 70-80% >I run the reclamation process. David - Another approach to scratch pool management is to wait until the number of scratches reaches a comfortable minimum, and only then start reclamation. I prefer to let attrition empty tapes as much as possible, rather than subject tapes to wear in copying remaining contents sooner than necessary - considering also that that remainder may expire soon anyway, making that much copying wasteful. >How can I have a tapes with 0 capacity and 0 utilization? What your display doesn't tell you is the state of the tapes. Particularly for a copy storage pool, REUsedelay should be in effect, and the volumes would thus be Pending. Richard Sims, BU
Re: Several tapes with zero capacity and zero utilization
Hi, I have the following alias in my .profile to provide scratch tape numbers. It's pretty simple (but it avoids the select commands that sometimes use lots of resources on my system). alias scratch="dsmadmc -id=qid -password=qpass q libv |grep Scratch |wc -l" Regards, Ben > Date: Wed, 18 Oct 2000 16:51:18 +0100 > From: "Warren, Matthew James" <[EMAIL PROTECTED]> > Subject: Re: Several tapes with zero capacity and zero utilization > To: [EMAIL PROTECTED] > MIME-version: 1.0 > Content-transfer-encoding: 7BIT > > Hello David, > > > I use, > > select count(*) from libvolumes where status='Scratch' > > > Matthew. > > > >Do you know of an _easy_ way to tell just how many scratch > >tapes we have? > > > >We are using select statements using the info in the volumes table. The > >problem is the tapes only show in stgpool_name as either copypool or > >tapepool. I run a select statement to get the number of > >copypool tapes then > >another to get the number of tapepool tapes. Then I have to add then > >together and subtract that from the number of tapes we put in > >the library to > >begin with. > > > >It's a convoluted process but that's the best I can come up > >right now. I > >can't find a direct way to tell me the number of scratch tapes I have. > > > >-Original Message- > >From: Richard Sims [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, October 18, 2000 10:44 AM > >To: [EMAIL PROTECTED] > >Subject: Re: Several tapes with zero capacity and zero utilization > > > > > >>When I get several tapes with a PCT_RECLAIM above 70-80% > >>I run the reclamation process. > > > >David - Another approach to scratch pool management is to wait until > >the number of scratches reaches a comfortable minimum, and > >only then start reclamation. I prefer to let attrition empty tapes > >as much as possible, rather than subject tapes to wear in copying > >remaining contents sooner than necessary - considering also that > >that remainder may expire soon anyway, making that much copying > >wasteful. > > > >>How can I have a tapes with 0 capacity and 0 utilization? > > > >What your display doesn't tell you is the state of the tapes. > >Particularly for a copy storage pool, REUsedelay should be in effect, > >and the volumes would thus be Pending. > > > > Richard Sims, BU > >
Re: Several tapes with zero capacity and zero utilization
I have a script that counts scratches- my 3494 is shared betweeen two tsm instances, so I use a table of category codes to sort out private/scratch for each tsm instance. This, of course, is from the library/category point of view, which may not necessarily balance 100% to TSM's! Here's the (ksh) script: lookup_code() { table=/usr/tivoli/tsm/etc/category_table desc=`grep ^$1 $table|awk -F= '{print $2}'` } echo echo echo "--- TSM carts ---" echo mtlib -l /dev/lmcp0 -qI|awk '{print $2}'|sort |uniq -c|while read count cat;do lookup_code $cat printf "%5d " $count echo $desc done Here's the category table (tsmSF1 and tsmSD1 are my tsm instance names) : 0190=tsmSF1 private 0191=tsmSF1 scratch 3490 0192=tsmSF1 scratch 3590 01F4=tsmSD1 private 01F5=tsmSD1 scratch 3490 01F6=tsmSD1 scratch 3590 F00E=volume in error FF10=eject pending FF11=bulk eject FF00=inserted. (unassigned, in ATL) FFF7=pending FFFA=manually ejected FFFB=purge volume FFFC=unexpected volume FFFA=purge volume FFFD=3590 cleaner FFFE=3490 cleaner =private volume Cleaner carts don't seem to show in the normal mtlib -qI command, so you can add the following to count these: echo echo "--- Cleaner Carts ---" echo mtlib -l /dev/lmcp0 -qC -s fffd|awk '{print $2}'|sort |uniq -c|while read count cat;do lookup_code $cat printf "%5d " $count echo $desc done But this still doesn't show us how many cleaning cycles are available on these cleaning carts, so add the following to display that (plus the library empty cell count): echo echo echo "--- Library Status ---" echo mtlib -l /dev/lmcp0 -qL|egrep "available cells|3590 cleaner cycles" echo Sample output: --- Cleaner Carts --- 4 3590 cleaner --- TSM carts --- 106 tsmSF1 private 82 tsmSF1 scratch 3590 46 tsmSD1 private 263 tsmSD1 scratch 3590 50 inserted. (unassigned, in ATL) --- Library Status --- available cells311 avail 3590 cleaner cycles..374 Comments, corrections, and other code swaps welcomed! JRS.
Re: Several tapes with zero capacity and zero utilization
For 3494's, you can use the mtilb command to count scratch tapes, or insert tapes - whatever class you want. I've got a shared library - 4 TSM servers, one 3494, and I run this script daily: echo "Scratch tapes on RTP1" > /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qC -s012E | wc -l >> /home/nickpc/data/scratchcount echo "Scratch tapes on RTP2" >> /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qC -s013E | wc -l >> /home/nickpc/data/scratchcount echo "Scratch tapes on RTP3" >> /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qC -s014E | wc -l >> /home/nickpc/data/scratchcount echo "Scratch tapes on RTP4" >> /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qC -s015E | wc -l >> /home/nickpc/data/scratchcount echo "Number of insert tapes in UR13494" >> /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qC -sFF00 | wc -l >> /home/nickpc/data/scratchcount mtlib -l /dev/lmcp0 -qL | grep Intervention >> /home/nickpc/data/scratchcount more -e /home/nickpc/data/scratchcount I have a second script that runs this one and then mails the output file to me. Nick Cassimatis [EMAIL PROTECTED] "I'm one cookie away from happy." - Snoopy (Charles Schulz)
Re: Several tapes with zero capacity and zero utilization
Hello David, I use, select count(*) from libvolumes where status='Scratch' Matthew. >Do you know of an _easy_ way to tell just how many scratch >tapes we have? > >We are using select statements using the info in the volumes table. The >problem is the tapes only show in stgpool_name as either copypool or >tapepool. I run a select statement to get the number of >copypool tapes then >another to get the number of tapepool tapes. Then I have to add then >together and subtract that from the number of tapes we put in >the library to >begin with. > >It's a convoluted process but that's the best I can come up >right now. I >can't find a direct way to tell me the number of scratch tapes I have. > >-Original Message- >From: Richard Sims [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, October 18, 2000 10:44 AM >To: [EMAIL PROTECTED] >Subject: Re: Several tapes with zero capacity and zero utilization > > >>When I get several tapes with a PCT_RECLAIM above 70-80% >>I run the reclamation process. > >David - Another approach to scratch pool management is to wait until >the number of scratches reaches a comfortable minimum, and >only then start reclamation. I prefer to let attrition empty tapes >as much as possible, rather than subject tapes to wear in copying >remaining contents sooner than necessary - considering also that >that remainder may expire soon anyway, making that much copying >wasteful. > >>How can I have a tapes with 0 capacity and 0 utilization? > >What your display doesn't tell you is the state of the tapes. >Particularly for a copy storage pool, REUsedelay should be in effect, >and the volumes would thus be Pending. > > Richard Sims, BU >
Re: Several tapes with zero capacity and zero utilization
>Do you know of an _easy_ way to tell just how many scratch tapes we have? David - From http://people.bu.edu/rbs/ADSM.QuickFacts: Scratches, number left SELECT COUNT(LIBVOLUMES.VOLUME_NAME) - as "Scratch volumes" FROM LIBVOLUMES - WHERE (LIBVOLUMES.STATUS='Scratch') Richard
Re: Several tapes with zero capacity and zero utilization
That sounds like an excellent idea. At the moment we are running short on tapes until we get a new batch in. Do you know of an _easy_ way to tell just how many scratch tapes we have? We are using select statements using the info in the volumes table. The problem is the tapes only show in stgpool_name as either copypool or tapepool. I run a select statement to get the number of copypool tapes then another to get the number of tapepool tapes. Then I have to add then together and subtract that from the number of tapes we put in the library to begin with. It's a convoluted process but that's the best I can come up right now. I can't find a direct way to tell me the number of scratch tapes I have. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 10:44 AM To: [EMAIL PROTECTED] Subject: Re: Several tapes with zero capacity and zero utilization >When I get several tapes with a PCT_RECLAIM above 70-80% >I run the reclamation process. David - Another approach to scratch pool management is to wait until the number of scratches reaches a comfortable minimum, and only then start reclamation. I prefer to let attrition empty tapes as much as possible, rather than subject tapes to wear in copying remaining contents sooner than necessary - considering also that that remainder may expire soon anyway, making that much copying wasteful. >How can I have a tapes with 0 capacity and 0 utilization? What your display doesn't tell you is the state of the tapes. Particularly for a copy storage pool, REUsedelay should be in effect, and the volumes would thus be Pending. Richard Sims, BU
Re: Several tapes with zero capacity and zero utilization
I did the q vol status=pending and it has the same tapes. They are pending. I had forgotten that the tapes stay in the pending status for three days. Thanks! -Original Message- From: Doug Thorneycroft [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 10:41 AM To: [EMAIL PROTECTED] Subject: Re: Several tapes with zero capacity and zero utilization They are probably pending, do a q vol status=pending and see if the list matches your zero capacity tapes. On Wednesday, October 18, 2000 7:10 AM, Tyree, David [SMTP:[EMAIL PROTECTED]] wrote: > 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.595.9 > 4.1 > SG0117 14658.097.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.799.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
Re: Several tapes with zero capacity and zero utilization
>When I get several tapes with a PCT_RECLAIM above 70-80% >I run the reclamation process. David - Another approach to scratch pool management is to wait until the number of scratches reaches a comfortable minimum, and only then start reclamation. I prefer to let attrition empty tapes as much as possible, rather than subject tapes to wear in copying remaining contents sooner than necessary - considering also that that remainder may expire soon anyway, making that much copying wasteful. >How can I have a tapes with 0 capacity and 0 utilization? What your display doesn't tell you is the state of the tapes. Particularly for a copy storage pool, REUsedelay should be in effect, and the volumes would thus be Pending. Richard Sims, BU
Re: Several tapes with zero capacity and zero utilization
They are probably pending, do a q vol status=pending and see if the list matches your zero capacity tapes. On Wednesday, October 18, 2000 7:10 AM, Tyree, David [SMTP:[EMAIL PROTECTED]] wrote: > 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.595.9 > 4.1 > SG0117 14658.097.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.799.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
Several tapes with zero capacity and zero utilization
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.595.9 4.1 SG0117 14658.097.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.799.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