You can try this:
select vol.volume_name, vol.pct_utilized -
from volumes vol, libvolumes libv -
where vol.volume_name=libv.volume_name -
and devclass_name='XXXX' -
order by vol.pct_utilized
Change the devclass with the one defined over the library or join also the
devclasses table.
Zlatko Krastev
IT Consultant
Ken Sedlacek <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
30.05.2003 16:31
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: How to List library tape volumes by Pct Util?
Enviro:
AIX TSM server 4.2.2.12 (I know, I need to upgrade!)
MagStar 3570 C12 library
Can someone suggest a query to list all the volumes in the library sorted
by "Pct Util"?
ps-I wish there was some way to find these queries that exist in the
adsm.org archives.
Does anyone know of some good keywords to use for a search on such a query
in the adsm archives??
TIA.
Ken Sedlacek
AIX/TSM/UNIX Administrator
[EMAIL PROTECTED]
IBM Certified Specialist: RS/6000 AIX v4.3 Support
IBM Certified Specialist: RS/6000 SP & PSSP 3
Tivoli Certified Consultant - Tivoli Storage Manager v4.1
