Thanks to all who responded:
Michael Moore
David E Ehresman
Richard Sims
Jeff White (off-line)
all of you suggestions are more than adequate.
Thank you!
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
Michael Moore <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
05/30/03 10:36 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to List library tape volumes by Pct Util?
select volume_name,stgpool_name,pct_utilized from volumes where
volume_name
like '3%' order by pct_utilized
Replace the 3% with whatever you tape volumes start with.
Hope this is what you are looking for.
Michael Moore
VF Services Inc.
105 Corporate Center Blvd.
Greensboro, NC 27408
336.424.4423 (Voice)
336.424.4544 (Fax)
336.507.5199 (Pager)
Ken Sedlacek
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
US.COM> cc:
Sent by: "ADSM: Subject: How to List
library tape volumes by Pct Util?
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
05/30/03 09:31 AM
Please respond to
"ADSM: Dist Stor
Manager"
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
