Results 1 to 6 of 6
  1. #1
    Member chris_magic's Avatar
    Join Date
    May 2007
    Location
    Quebec, Qc, Canada
    Posts
    178
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Number of tape per node

    Hi,

    I wish to have a script that allows me to know the number of tape used by a specific node from a storage pool specific.

    Thanks in advance for your help.
    Christophe Chirat - TSM Consultant for LGS Inc
    Tivoli Storage Manager 6.2 "Implementation" Certified
    ITIL Certified
    LinkedIn

  2. #2
    Member
    Join Date
    Oct 2009
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    select distinct(volume_name) from volumeusage where node_name='NODENAME' and stgpool_name='STGPOOLNAME'

  3. #3
    Member chris_magic's Avatar
    Join Date
    May 2007
    Location
    Quebec, Qc, Canada
    Posts
    178
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Unfortunately this doesn't work.
    Christophe Chirat - TSM Consultant for LGS Inc
    Tivoli Storage Manager 6.2 "Implementation" Certified
    ITIL Certified
    LinkedIn

  4. #4
    Member
    Join Date
    Oct 2009
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    It should work ...This is the output from one of the tsm servers which we are handling.Please try once again

    tsm: *****>select distinct(volume_name) from volumeusage where node_name='VAL89709' and stgpool_name='WIN_PRI'

    VOLUME_NAME
    ------------------
    TN40756
    TN41120

  5. #5
    Member chris_magic's Avatar
    Join Date
    May 2007
    Location
    Quebec, Qc, Canada
    Posts
    178
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    tsm : *********>select distinct(volume_name) from volumeusage where node_name='DMZ00DMZQC00055' and stgpool_name='lto3_pool'
    ANR2034E SELECT: No match found using this criteria.
    ANS8001I Code de retour 11.

    OR

    tsm : TCN00QUBC00076>Select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='DMZ00DMZQC00055' and stgpool_name='LTO3_POOL'

    HTML Code:
    NODE_NAME              VOLUME_NAME            STGPOOL_NAME
    ------------------     ------------------     ------------------
    DMZ00DMZQC00055        300011                 LTO3_POOL
    DMZ00DMZQC00055        300016                 LTO3_POOL
    DMZ00DMZQC00055        300021                 LTO3_POOL
    DMZ00DMZQC00055        300028                 LTO3_POOL
    DMZ00DMZQC00055        300038                 LTO3_POOL
    I would like a script that makes me the total number of tapes.

  6. #6
    Member chris_magic's Avatar
    Join Date
    May 2007
    Location
    Quebec, Qc, Canada
    Posts
    178
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    The solution:

    select count(distinct volume_name) as "Number of tapes" FROM volumeusage where stgpool_name='STGPOOL_NAME' and node_name='NODE_NAME'

    or

    select stgpool_name, count(distinct volume_name) as "Number of tapes" FROM volumeusage where node_name='NODE_NAME' GROUP BY stgpool_name
    Last edited by chris_magic; 09-09-2010 at 01:29 PM.
    Christophe Chirat - TSM Consultant for LGS Inc
    Tivoli Storage Manager 6.2 "Implementation" Certified
    ITIL Certified
    LinkedIn

Similar Threads

  1. ANR2716E after changing Node IP-Number
    By Ziegenhardt in forum TSM Client
    Replies: 3
    Last Post: 04-30-2009, 03:32 PM
  2. High number of tapes used by node
    By Leandro Freitas in forum Backup / Archive Discussion
    Replies: 7
    Last Post: 09-12-2008, 02:47 PM
  3. How to find out number of backed up versions of all files of a node.
    By mohit in forum TSM Documentation,Tips and Tricks
    Replies: 1
    Last Post: 07-06-2006, 09:10 PM
  4. How to find out number of backed up versions of all files of a node.
    By mohit in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 04-05-2006, 05:30 AM
  5. number of tapes of one restore incremental of a TSM node
    By jomamilo in forum Administrative Client
    Replies: 4
    Last Post: 02-28-2006, 03:01 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •