• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1263
  • Last Modified:

TSM Tape/Iron mountain inventory

Is there a command/query using which I can find out what all tapes are there in "vault". I know the query "select volume_name from volumes where DEVCLASS_NAME = 'TDEV3592' and LOCATION = 'VAULT'", but my question is how can i get those tapes which are there in vault before one month. This I need as I am implementing a inventory process wherein I need to check that all my tapes going to offsite (Iron mountain) are coming back after a month retention period and none of the tapes are getting missed. So, using this command I can get the tapes which were in vault before one month, compare this with IM inventory and find the delta which is nothing but the tapes to be recalled. kindly help me in that query.

Thanks
virgo
0
virgo0880
Asked:
virgo0880
  • 2
  • 2
1 Solution
 
woolmilkporcCommented:
Try this:

select VOLUME_NAME, date(UPD_DATE) DATE                    -
from DRMEDIA                                                                -
where                                                                            -
LIB_NAME='LIB3494'                                                       -
and LOCATION = 'VAULT'                                                -
and days(CURRENT TIMESTAMP)>days(UPD_DATE)+30     -
order by 2

Replace LIB3494 with the name of your automated tape library.

wmp
0
 
virgo0880Author Commented:
I tried that query, but I am getting nothing :

select VOLUME_NAME, date(UPD_DATE) DATE from DRMEDIA where LIB_NAME='L3494B' and LOCATION = 'VAULT' and days(CURRENT TIMESTAMP)>days(UPD_DATE)+30 order by 2

NR2034E SELECT: No match found using this criteria.

Can u explain "days(CURRENT TIMESTAMP)>days(UPD_DATE)+30 order by 2" part ?

virgo
0
 
woolmilkporcCommented:
days(CURRENT TIMESTAMP)  is the current date expressed in days since 01/01/00.

days(UPD_DATE) is the date of the last update (where the location was changed to VAULT) expressed in days since 01/01/00.

We search for UP_DATE more than 30 days before now.

If you get nothing - don't you use MOVE DRMEDIA for vaulting? What does Q DRMEDIA say?

If you use a different method (is there one?) you can try applying the date restriction against CHG_TIME of VOLUMES, but I'm really unsure if this would actually reflect the change of the location to VAULT, sorry!

wmp
0
 
virgo0880Author Commented:
Q DRMEDIA shows me list of tapes wherein some shows in vault state, some in mountable and some in vault retrieve.  What does this mean. Also we have a script  which will eject the tapes which will ran by support people to eject the tapes daily. I am bit confused with the states being showed above - what they exactly means. I can attach our script with this for better understanding.

virgo eject-script.txt
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now