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