Hmmm.... When I do "show volumeusage NODENAME", I get no result, regardless of node....
Paul On Wed, Jun 29, 2011 at 2:49 PM, Shawn Drew < [email protected]> wrote: > I would go with the volumeusage table instead of contents if you just want > the tapes for a node. > select distinct(volume_name) from volumeusage where node_name='NODENAME' > (that will show copypool volumes also) > > Alternatively, there is a show command: > show volumeusage NODENAME > > > Regards, > Shawn > ________________________________________________ > Shawn Drew > > > > > > Internet > [email protected] > > Sent by: [email protected] > 06/29/2011 09:09 AM > Please respond to > [email protected] > > > To > ADSM-L > cc > > Subject > Re: [ADSM-L] volumes associated with a node > > > > > > > select volume_name from contents where node_name like '%nodename%' and > FILESPACE_NAME like '%Filespacename%' and FILE_NAME like '%Filename%' > > On Wed, Jun 29, 2011 at 3:48 PM, molin gregory > <[email protected]>wrote: > > > Hello, > > > > Try : q nodedata NODENAME stg=XXXX > > > > Cordialement, > > Grégory Molin > > Tel : 0141628162 > > [email protected] > > > > -----Message d'origine----- > > De : ADSM: Dist Stor Manager [mailto:[email protected]] De la part de > > Tim Brown > > Envoyé : mercredi 29 juin 2011 14:40 > > À : [email protected] > > 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: [email protected] <<mailto:[email protected]>> > > Phone: 845-486-5643 > > Fax: 845-486-5921 > > Cell: 845-235-4255 > > > > > > > > > > This message contains confidential information and is only for the > intended > > recipient. 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, please notify the sender immediately by replying to this note > and > > deleting all copies and attachments. > > > > "ATTENTION. > > > > Ce message et les pièces jointes sont confidentiels et établis à > > l'attention exclusive de leur destinataire (aux adresses spécifiques > > auxquelles il a été adressé). Si vous n'êtes pas le destinataire de ce > > message, vous devez immédiatement en avertir l'expéditeur et supprimer > ce > > message et les pièces jointes de votre système. > > > > This message and any attachments are confidential and intended to be > > received only by the addressee. If you are not the intended recipient, > > please notify immediately the sender by reply and delete the message and > any > > attachments from your system. " > > > > > > -- > Thanks & Regards, > Sarav > +974-3344-1538 > > There are no secrets to success. It is the result of preparation, hard > work > and learning from failure - Colin Powell > > > > This message and any attachments (the "message") is intended solely for > the addressees and is confidential. If you receive this message in error, > please delete it and immediately notify the sender. Any use not in accord > with its purpose, any dissemination or disclosure, either whole or partial, > is prohibited except formal approval. The internet can not guarantee the > integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) > not therefore be liable for the message if modified. Please note that > certain > functions and services for BNP Paribas may be performed by BNP Paribas RCC, > Inc. >
