[ADSM-L] SQL question
2009-10-29 17:07:45
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] SQL question,
Fred Johanson <=
|
|
|