TSM Tape/Iron mountain inventory

Posted on 2011-05-03
Last Modified: 2013-11-14
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.

Question by:virgo0880
    LVL 68

    Accepted Solution

    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.


    Author Comment

    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 ?

    LVL 68

    Expert Comment

    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!


    Author Comment

    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

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Throughout my career I’ve read many articles and performed due diligence on recovering VM’s that broke on the XenServer platform. From my experience and perspective it seems to be an ample amount of confusion as to a good base method to start with. …
    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now