1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Finding which tapes are missing from the library

Discussion in 'Backup / Archive Discussion' started by ears, Oct 11, 2012.

  1. ears

    ears Active Newcomer

    Joined:
    Jul 27, 2010
    Messages:
    42
    Likes Received:
    0
    Hi,

    A while ago we ran out of slots in our library, so we just removed some "full" tapes and loaded scratch so that we could get a backup. The full tapes were sent off site. We have now upgraded the library with more slots.
    When we try to run reclamation it tells us that certain tapes are needed that are not in the library. Does anyone have a command that i could run to list all tapes that should be in the library so that we can run reclamation without issue?
    Many thanks
     
  2.  
  3. tsmdumber

    tsmdumber ADSM.ORG Member

    Joined:
    Jan 27, 2011
    Messages:
    108
    Likes Received:
    3
    All primary tapes should be inside the library as a start!

    select volume_name from volumes where STGPOOL_NAME='PRIMARY_STG' and volume_name not in ( select volume_name from libvolumes)

    above command should get some info
     
  4. DazRaz

    DazRaz ADSM.ORG Senior Member

    Joined:
    Jun 15, 2008
    Messages:
    114
    Likes Received:
    8
    This will depend on whether you used the move media command to remove the full tapes. If you did, then the command will be :

    q media * stg=<storage_pool_name> wherestate=mountablen

    If you didn't, when reclaimation attempted to run, it would have failed marking the tapes as unavailable. This could be used.

    q vol stg=<storage_pool_name> access=unavail

    You could also search the event log for reclaim failures. To search the last day you would use this:

    q act begind=-1 msg=1163
     

Share This Page