virgo0880
asked on
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
Thanks
virgo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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
virgo eject-script.txt
ASKER
select VOLUME_NAME, date(UPD_DATE) DATE from DRMEDIA where LIB_NAME='L3494B' and LOCATION = 'VAULT' and days(CURRENT TIMESTAMP)>days(UPD_DATE)+
NR2034E SELECT: No match found using this criteria.
Can u explain "days(CURRENT TIMESTAMP)>days(UPD_DATE)+
virgo