Try this

select count(volume_name), vu.node_name from volume_usage vu, nodes n
where vu.node_name=n.node_name and copy_type='BACKUP' and stgpool_name
!= 'OFFSITEPPOOL' and  n.domain_name='SYSSERV'

Regards

Steve Harris
Unemployed and Impoverished TSM Admin
Sydney Australia


Fred Johanson wrote:

Management would like to know how many tapes are being used by each 
domain(=administrative unit).  Logically, I think the query should look like 
this:

select count(volume_name),node_name from volumeusage where copy_type='BACKUP' 
and not stgpool_name='OFFSITEPOOL' and node_name in (select node_name from 
domains where domain_name='SYSSERV')

But that produces this message

ANR2942E The column reference 'NODE_NAME' is not allowed in this context 
because it is part of an outer SQL query expression.

Any thoughts?


Fred Johanson
TSM Administrator
University of Chicago

773-702-8464
------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.423 / Virus Database: 270.14.38/2467 - Release Date: 10/29/09 
07:38:00