Re: volumes associated with a node

2011-06-29 Thread J. Pohlmann
-Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul Fielding Sent: Wednesday, June 29, 2011 15:49 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes associated with a node Hmmm When I do "show volumeusage NODENAME", I get no result,

Re: volumes associated with a node

2011-06-29 Thread Paul Fielding
_ > Shawn Drew > > > > > > Internet > evergreen.sa...@gmail.com > > Sent by: ADSM-L@VM.MARIST.EDU > 06/29/2011 09:09 AM > Please respond to > ADSM-L@VM.MARIST.EDU > > > To > ADSM-L > cc > > Subject > Re: [ADSM-L] volumes asso

Re: volumes associated with a node

2011-06-29 Thread Steven Langdale
ADSM-L@VM.MARIST.EDU] De la part de > > Tim Brown > > Envoyé : mercredi 29 juin 2011 14:40 > > À : ADSM-L@VM.MARIST.EDU > > Objet : [ADSM-L] volumes associated with a node > > > > Is there a select statement that will list all tape volumes that have > files

Re: volumes associated with a node

2011-06-29 Thread Steven Langdale
On 29 June 2011 13:39, Tim Brown wrote: > Is there a select statement that will list all tape volumes that have files > for > > a given TSM node. > > select distinct VOLUME_NAME,STGPOOL_NAME from volumeusage where NODE_NAME='' = the node name in upper case. It also returns the stgpool

Re: volumes associated with a node

2011-06-29 Thread Shawn Drew
ds, Shawn Shawn Drew Internet evergreen.sa...@gmail.com Sent by: ADSM-L@VM.MARIST.EDU 06/29/2011 09:09 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] volumes associated with a node select volume_name from cont

Re: volumes associated with a node

2011-06-29 Thread Saravanan Palanisamy
dialement, > Grégory Molin > Tel : 0141628162 > gregory.mo...@afnor.org > > -Message d'origine- > De : ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] De la part de > Tim Brown > Envoyé : mercredi 29 juin 2011 14:40 > À : ADSM-L@VM.MARIST.EDU > Obje

Re: volumes associated with a node

2011-06-29 Thread molin gregory
Objet : [ADSM-L] volumes associated with a node Is there a select statement that will list all tape volumes that have files for a given TSM node. Thanks, Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@c

volumes associated with a node

2011-06-29 Thread Tim Brown
Is there a select statement that will list all tape volumes that have files for a given TSM node. Thanks, Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com <> Phone: 845-486-5643