Does anyone have a easy way to find out which tapes are supposed to
be in the vault? I need to check every so often to make sure the operator is
bringing back the tapes correctly. I'm not sure if the following is correct:
select volume_name as "Tape Number" from drmedia where state='VAULT
idea...
-Original Message-
From: Tyree, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: List of tapes in vault
Does anyone have a easy way to find out which tapes are supposed to
be in the vault? I need to check every so oft
You don't need select for this simple one. Use:
q drmedia * wheresate=vaultr
You can use same command with all other states to see where they are.
I have our vault send me an inventory about every 2 months and I
compare. You have to remember that their "snapshot" of the
Vault and yours will
el C. Wiley
ADSM/TSM Administrator
AIX Support
Phone 1-614-308-6709
Pager 1-877-489-2867
Fax 1-614-308-6637
Cell 1-740-972-6441
Siempre Hay Esperanza
"Tyree, David"
cc:
Sent by: "ADSM:
David
Try asking for what is not in your library. The select below will list
every tape not in the library. So, this would also include tapes being
transported to/from the vault.
select volume_name as "Tape Number", location from drmedia where lib_name
is null
Rick Saylor
Austin Community Colle
: List of tapes in vault
David
I am not sure that will include the database backups that you may or
may not
be sending offsite
q drm wherest=vault source=dbsnapshot(or whatever your dbbackup is) will
give you a list of all in vault status. You can add to that
vaultretrieve
or just leave the wherest