I use select * from volumes where upper(access)='UNAVAILABLE' HTH Thomas Rupp
-----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Avy Wong Gesendet: Dienstag, 30. Jänner 2007 17:14 An: [email protected] Betreff: [ADSM-L] volumes with unavailable status only Hello, How do you go about getting a list of volumes that shows with access=unavailable only. I tried many versions of select statement but not getting it right. Thanks. tsm: TSM>q vol DR5057 f=d Volume Name: DR5057 Storage Pool Name: 3584TAPEPOOL Device Class Name: 3584 Estimated Capacity: 200,000.0 Scaled Capacity Applied: Pct Util: 3.7 Volume Status: Filling Access: Unavailable Pct. Reclaimable Space: 3.4 Scratch Volume?: Yes In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 23 Write Pass Number: 1 Approx. Date Last Written: 10/10/2006 11:38:28 Approx. Date Last Read: 01/12/2007 16:43:49 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: Volume is MVS Lanfree Capable : No Last Update by (administrator): WONGAV Last Update Date/Time: 01/12/2007 16:46:26 Begin Reclaim Period: End Reclaim Period: Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 ext 28164 ************************************************************************************************** The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. **************************************************************************************************
