missing volumes
Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: missing volumes
Why don't you just check the volumes whose access is offsite and whose status is empty ? This is what I do. And to be sure that all volumes present in library are in an readwrite status, I just put all the volumes of the copypool in offsite state and then all the volumes of the libvol in readwrite state. For that, I use a Shell script which is below. The only thing which is special is that I only have private volumes and all the volumes of my copy pool have a name starting with 'COP' But I guess it wouldn't be very difficult to make a check on the libvol volumes to select the ones which belong to the copy pool #!/bin/ksh LIBVOLS=$(dsmadmc -id=admin -pa=admin select volume_name from libvolumes where volume_name like 'C%' | grep COP) TOTVOLS=$(dsmadmc -id=admin -pa=admin select volume_name from volumes where volume_name like 'C%' | grep COP) for VOL in $TOTVOLS do dsmadmc -id=admin -pa=admin upd vol $VOL acc=offsite done for VOL in $LIBVOLS do dsmadmc -id=admin -pa=admin upd vol $VOL acc=readw done Etienne GUILLAUMONT e-mail : [EMAIL PROTECTED] RGB Technologie Parc d'Innovation, Batiment PYTHAGORE 11 Rue Jean SAPIDUS 67400 ILLKIRCH Tél : 03 90 40 60 60 Fax : 03 90 40 60 61 Henrik WahlstedtTo: [EMAIL PROTECTED] shwl@STATOILcc: .COMSubject: missing volumes Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 29/08/02 12:45 Please respond to ADSM: Dist Stor Manager Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: missing volumes
Select volume_name from volumes where volume_name not in (select volume_name from libvolumes) Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 6:46 AM To: [EMAIL PROTECTED] Subject: missing volumes Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: missing volumes
Henrik, what platform are you running on? I used to the 'checkin libv library search=bulk checklabel=barcode stat=pri' and then pull the ANR8430I messages from the log, strip the volume (third field) out and generate the 'upd vol XX acce=readw' commands to run through a batch process. Now I've got a perl script that tails the log and updates the volume as soon as the checkin completes. I discovered a long time ago what you are running into, and quit using wildcards on checkin scripts. Tom Kauffman NIBCO, Inc -Original Message- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 7:58 AM To: [EMAIL PROTECTED] Subject: Re: missing volumes I do, but if I for some reason only get 9 of 10 volumes back where access=offsite and status=empty, and I did not notice that one is missing. Following will happen after I checked in my 9 volumes and vol 000146 is not checked in. After a time, how would I know that my missing volume is vol 000146? tsm: STO-W03q vol st=emp Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 000146COPYPOOL DLTCLASS 0.0 0.0 Empty tsm: STO-W03upd vol 000146 access=readw wherestg=copypool whereaccess=offsite w herestatus=empty ANR2208I Volume 000146 deleted from storage pool COPYPOOL. tsm: STO-W03q vol 000146 ANR2034E QUERY VOLUME: No match found using this criteria. ANS8001I Return code 11. tsm: STO-W03q libv stk9710 000146 ANR2034E QUERY LIBVOLUME: No match found using this criteria. ANS8001I Return code 11. //Henrik GUILLAUMONT Etienne eguillau@RGB-TECHNTo: [EMAIL PROTECTED] OLOGIE.FR cc: (bcc: Henrik Wahlstedt) Sent by: ADSM:Subject: Re: missing volumes Dist Stor Manager [EMAIL PROTECTED] DU 2002-08-29 14:01 Please respond to ADSM: Dist Stor Manager Why don't you just check the volumes whose access is offsite and whose status is empty ? This is what I do. And to be sure that all volumes present in library are in an readwrite status, I just put all the volumes of the copypool in offsite state and then all the volumes of the libvol in readwrite state. For that, I use a Shell script which is below. The only thing which is special is that I only have private volumes and all the volumes of my copy pool have a name starting with 'COP' But I guess it wouldn't be very difficult to make a check on the libvol volumes to select the ones which belong to the copy pool #!/bin/ksh LIBVOLS=$(dsmadmc -id=admin -pa=admin select volume_name from libvolumes where volume_name like 'C%' | grep COP) TOTVOLS=$(dsmadmc -id=admin -pa=admin select volume_name from volumes where volume_name like 'C%' | grep COP) for VOL in $TOTVOLS do dsmadmc -id=admin -pa=admin upd vol $VOL acc=offsite done for VOL in $LIBVOLS do dsmadmc -id=admin -pa=admin upd vol $VOL acc=readw done Etienne GUILLAUMONT e-mail : [EMAIL PROTECTED] RGB Technologie Parc d'Innovation, Batiment PYTHAGORE 11 Rue Jean SAPIDUS 67400 ILLKIRCH Tel : 03 90 40 60 60 Fax : 03 90 40 60 61 Henrik WahlstedtTo: [EMAIL PROTECTED] shwl@STATOILcc: .COMSubject: missing volumes Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 29/08/02 12:45 Please respond to ADSM: Dist Stor Manager Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik --- The information contained
Re: missing volumes
Henrik Wahlstedt wrote: Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you. Hi Tia, I see you have several answers already, however nobody has mentioned using the move media and the q media commands. That is exactly what they are intended to do, i.e. manage tape volumes (both primary and copy) in an automated library. I then just take it one step further and use the cmd attribute to build a macro that does my update vols to set the access to offsite. For the return trip, I simply do a q vol similar to your upd vol above to get a list of the volumes that need to come home, again I use the cmd attribute to build my macro to do the upd vol commands. Since all my volumes start life as scratch volumes (i.e. not private and added to stgpool by def vol) as soon as I do the upd vol acc=readw ... the volumes become scratch volumes. At that point I either check them into the library as scratch or put them aside as scratch volumes to be checked in later. I have done this at several locations to replace the offsite tape management feature of DRM. However, there is one more tape management feature that DRM handles and that is your DB backup volumes. I handle this thru upd volh, q volh, del volh and some simple scripting to check the volumes out, And as before, when its time for the tape to come home I simply do the del volh and its a scratch tape again. As far as your first question about comparing volume names between the volumes table and the libvolumes table, I am not sure that would give you what you are looking for. I guess you would have to give me more criteria for the search, i.e list volume names in volumes but not in libvolumes and volume access is not offsite. If you can provide that I will be glad to write the select for you. I hope this helped and good luck to you. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE ===
Re: missing volumes
Does ADSM kepp in its db a VOLUME-physical location relationship or does it ask the atape driver to find the volume XYZ, which atape then does a command such as 'tapeutil -f /dev/smc0 inventory, which it then gets the tape, loads it(or whatever)and tells adsm that the tape is there? Steve - My understanding is that for tape hardware that involves Element numbers - which is to say that TSM directly controls - TSM keeps track of what volume is in what element (slot). In the SCSI...Device Drivers manual, the SMCIOC_LOAD_MEDIUM ioctl command loads a tape from a specific slot into the drive: the application therefore has to know what volume happens to be in that slot, and performing an inventory each time would be excessive overhead. Do a 'Query LIBVolumes' on your system. That reports a Home Element, which I believe will show the correspondence between the volser and slot, as cataloged by TSM. (I don't have an SMC to try to corroborate this.) I believe that the TSM AUDit LIBRary command will bring TSM's catalog of volumes back into sync with contents and locations with the SMC. Richard Sims, BU
Re: missing volumes
Hi All - just a quickie... Does ADSM kepp in its db a VOLUME-physical location relationship or does it ask the atape driver to find the volume XYZ, which atape then does a command such as 'tapeutil -f /dev/smc0 inventory, which it then gets the tape, loads it(or whatever)and tells adsm that the tape is there? Can someone please help me? cheers steve ** Bunnings Legal Disclaimer: 1) This document is confidential and may contain legally privileged information. If you are not the intended recipient you must not read, copy, distribute or act in reliance on it. If you have received this document in error, please telephone us immediately on (08) 9365-1555. 2) All e-mails sent to and sent from Bunnings Building Supplies are scanned for content. Any material deemed to contain inappropriate subject matter will be reported to the e-mail administrator of all parties concerned. **
Re: missing volumes
Hi Steve, Yes, the tape is scratchable, but you have to explicitly update libvol 3575lib1 11824f status=scratch. You might want to q content 11824f first just to make sure there isn't anything on the tape. As you surmised, the library gets confused sometimes and when it can't find the tape it was looking for it marks the tape private so that TSM doesn't look for it any more. - Kai. Date:Fri, 13 Jul 2001 09:46:05 +0800 From:Steve de Souza [EMAIL PROTECTED] Subject: missing volumes Hi All, I have some volumes which appears in a q libv as follows...(ythis is just one of them) 3575LIB1 11824F Private59 The usual forth field of Data is not displayed. Does this mean that this is a scratchable tape??? Also, from the actlog, the last entry for this tape is an atempted checkin, which has failed as ADSM says that the tape is already in the library. The next most recent entry for the tape is a checkout from the library, which has failed, because the tape it got was the wrong one(I think the inventory is stuffed.) As I am physically holding this tape in my hand, I am very confused as to what is going on. Several tapes are like this. It also seems that after doing a tapeutil -f /dev/smc0 inventory that some of the tapes that are displayed are not the ones that physically appear in the slot that it says. Quite strange. Has anyone got some clues on how to sanity check and fix this inventory issue please? cheers steve
missing volumes
Hi All, I have some volumes which appears in a q libv as follows...(ythis is just one of them) 3575LIB1 11824F Private59 The usual forth field of Data is not displayed. Does this mean that this is a scratchable tape??? Also, from the actlog, the last entry for this tape is an atempted checkin, which has failed as ADSM says that the tape is already in the library. The next most recent entry for the tape is a checkout from the library, which has failed, because the tape it got was the wrong one(I think the inventory is stuffed.) As I am physically holding this tape in my hand, I am very confused as to what is going on. Several tapes are like this. It also seems that after doing a tapeutil -f /dev/smc0 inventory that some of the tapes that are displayed are not the ones that physically appear in the slot that it says. Quite strange. Has anyone got some clues on how to sanity check and fix this inventory issue please? cheers steve ** Bunnings Legal Disclaimer: 1) This document is confidential and may contain legally privileged information. If you are not the intended recipient you must not read, copy, distribute or act in reliance on it. If you have received this document in error, please telephone us immediately on (08) 9365-1555. 2) All e-mails sent to and sent from Bunnings Building Supplies are scanned for content. Any material deemed to contain inappropriate subject matter will be reported to the e-mail administrator of all parties concerned. **