Re: How to List library tape volumes by Pct Util?
2003-05-30 14:18:57
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
|
|
|