Hi,
Yes, you can suppress the prompt.
Just do: dsmadmc -noconfirm
Allan Hansen
Munk IT A/S
Egelundsvej 18
5260 Odense S
Denmark
"Ubhaykar, Nitin" <NUBHAYKA AT KOCKW DOT COM>
Sendt af: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11-02-2003 18:43
Besvar venligst til "ADSM: Dist Stor Manager"
Til: ADSM-L AT VM.MARIST DOT EDU
cc:
Vedr.: Re: Tape question
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:PFord AT STENTOR DOT COM]
Sent: Tue, February 11, 2003 8:20 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Tape question
> -----Original Message-----
> From: Remeta, Mark [mailto:MRemeta AT SELIGMANDATA DOT COM]
> Sent: Tuesday, February 11, 2003 9:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
pford AT stentor DOT com
|