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 <Ken_Sedlacek AT KYRUS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
30.05.2003 16:31
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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
ksedlacek AT kyrus DOT com

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