Hi, i tried a variation of your SQL, viz. select node_name, filespace_name from volumeusage where volume_name='----' - i ran this query on a volume containing objects from a remote server.
it worked fine, but before giving the result, it came back with a TSM prompt saying : "This SQL query might generate a big table, or take a long time. Do you wish to continue ? Y/N" i want to run this SQL in a batch file for many similar volumes, is there any way i can suppress the above-mentioned TSM prompt ? -----Original Message----- From: Peter Ford [mailto:[EMAIL PROTECTED]] Sent: Tue, February 11, 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: Tape question > -----Original Message----- > From: Remeta, Mark [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 9:14 AM > To: [EMAIL PROTECTED] > Subject: Tape question > > > I know this has been covered before but I can't find it. Does > anyone have a > sql query that will tell me what tapes a particular nodes > particular archive > is on? select volume_name,filespace_name from volumeusage where node_name='<NODE NAME>' Throwing in the file space name allows you to see what specific file space is stored on each tape. Hope this helps. Peter Peter Ford System Engineer Stentor, Inc. 5000 Marina Blvd, Brisbane, CA 94005-1811 Main Phone: 650-228-5555 Fax: 650 228-5566 http://www.stentor.com [EMAIL PROTECTED]
