Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List copy pool volumes currently checked in the library

ADSM/TSM Troubleshooting Tips

List copy pool volumes currently checked in the library

by  LED888  Posted    (Edited  )
Problem:
This document offers a command to identify which Tivoli Storage Manager server copy storage pool volumes are currently checked in the library.

Symptom:
In a case where the physical library is full, it may be necessary to checkout some tapes to make room for scratch tapes. A select command is available to identify copy storage pool volumes that can be sent to the vault.

Resolving the problem:
Use the below Tivoli Storage Manager server administrative command :

select volume_name from libvolumes where volume_name in (select volume_name from volumes a, stgpools b where a.stgpool_name=b.stgpool_name and b.pooltype='COPY')

This command will list the copy storage pool volumes that are checked in the library. Use the MOVE DRMEDIA or CHECKOUT LIBVOL command to remove the tapes from the library if necessary.


Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top