Heres one I use regularly select volume_name, stgpool_name, pct_utilized, pct_reclaim, status, - (date(last_write_date)) as DATE - from volumes - where volume_name in (select volume_name from libvolumes) - order by 2,4
Allan Mills | AIX and TSM Administrator Business & Technology Services | New South Wales Police 8835 9286 (internal 29286) Paul Dudley <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 14/06/2006 17:24 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject [ADSM-L] q vol and q libvol Rather than going back and forth between the output of the "q vol" and "q libvol" commands is there a command that would give me the output from the "q vol" command but only for those tape volumes that show up in the "q libvol" command? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. All mail is subject to content scanning for possible violation of New South Wales Police electronic Mail Policy. All persons are required to familiarise themselves with the content of the policy located on the NSWP Intranet BULLETIN BOARD. This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. If you have received it by mistake, please let us know by reply and then delete it from your system; you should not copy the message or disclose its contents to anyone.
