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
