Larry,

Your query works fine if you switch the double quotes to single quotes.

This query will tell you where every node resides.

select distinct vu.stgpool_name, -
         vu.node_name, -
         vu.volume_name, -
         v.pct_utilized -
  from volumeusage vu, -
         volumes v -
  where v.volume_name=vu.volume_name -
  order by vu.stgpool_name, -
         vu.node_name, -
         v.pct_utilized

As multiple nodes can and probably do exist on each tape, this can be a very
long list unless further qualified.

Bob

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Larry Clark
Sent: Wednesday, January 07, 2009 3:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Request for some TSM queries to use

Hi,
My TSM query usage is a bit rusty. These days it's VIO builds but I need to
participate in a customer DR exercise and will be restoring files to AIX
servers by fs (mount point). To avoid resource conflicts I'd like to be able
to determine what filespaces are on what volumes by node. Would this do it
from the TSN command line? Since I normally do not have access to the TSM
server I will not be able to test it until the DR exercise:

SELECT VOLUMEUSAGE.NODE_NAME, VOLUMEUSAGE.COPY_TYPE,
VOLUMEUSAGE.FILESPACE_NAME, VOLUMEUSAGE.STGPOOL_NAME,
VOLUMEUSAGE.VOLUME_NAME FROM VOLUMEUSAGE
WHERE (((VOLUMEUSAGE.NODE_NAME)="MY_NODE_NAME") AND
((VOLUMEUSAGE.STGPOOL_NAME)="MY_STG_POOL"));

Also, does anyone have a query that would produce a list of what nodes
occupy what volumes? We may have time to produce an overall usage list while
the mksysbs are being restored prior to the restore of the mount points.

Thank you

This electronic transmission and any documents accompanying this electronic 
transmission contain confidential information belonging to the sender.  This 
information may be legally privileged.  The information is intended only for 
the use of the individual or entity named above.  If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or the taking of any action in reliance on or regarding the contents of this 
electronically transmitted information is strictly prohibited.