IF your tape stgpool is collocated (you have to consider if a node has offsite tape volumes and if that stgpool has colocation on or off as well) AND you want to know how many tapes a node spans... try this: tsm: ADSM>select node_name, count(distinct volume_name) from volumeusage where node_name='PBSXDR00002' and stgpool_name like '%TAPE' group by node_name
I gave the select statement the node name, I also provided the a partial stgpoolname (that will just get my local, non-vaulted, tapes that ARE collocated....(stgpool_name like '%TAPE')). FYI...this will take a couple of minutes depending on your db, etc. tsm: ADSM>select node_name, count(distinct volume_name) from volumeusage where node_name='PBSXDR00002' and stgpool_name like '%TAPE' group by node_name ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute. Do you wish to proceed? (Yes (Y)/No (N)) y NODE_NAME Unnamed[2] ------------------ ----------- PBSXDR00002 218
