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
===============================================================================