Try:
select volume_name from volumeusage where node_name in -
(select node_name from nodes where domain_name='DEPTXYZ') and -
stgpool_name='DLT_BACKUP_POOL' group by volume_name
or:
select volume_name from volumeusage where node_name in -
('NODE1', 'NODEB') and stgpool_name='DLT_XYZ_POOL' group by volume_name
The first assumes that all nodes for the department are in the DEPTXYZ
domain. The 'and stgpool...' may be superfluous if you don't have
volumes in other stgpools to worry about (or if they are disk volumes
that you can easily ignore in the output).
If the volumes in DLT_BACKUP_POOL are not collocated, you may want to
make DLT_XYZ_POOL collocated, then do move data back to DLT_BACKUP_POOL
for volumes created in DLT_XYZ_POOL which don't belong.
Cheers...
Bruce
Naveed Mustafa wrote:
>
> Hello there,
>
> At present, I have one tape storage pool, DLT_BACKUP_POOL, backing up the
> data for all ADSM clients. One of our departments would like us to create
> a separate storage pool, DLT_XYZ_POOL, and move data belonging to all ADSM
> clients in their department from DLT_BACKUP_POOL to this newly created tape
> storage pool.
>
> Once the new tape storage pool is created, I can issue MOVE DATA command to
> move data from the volumes in DLT_BACKUP_POOL containing the data of all
> ADSM clients in this department to the new storage pool.
>
> What is troubling me is how would I go about finding out which volumes in
> DLT_BACKUP_POOL contains data for the ADSM clients in this department? I
> have over 500 tapes in the DLT_BACKUP_POOL and therefore running QUERY
> CONTENT command for each one will take me forever to identify volumes
> containing the information for the required clients. I do have collocation
> turned on DLT_BACKUP_POOL and the department has 15 clients that are
> sending their data to DLT_BACKUP_POOL.
>
> Is there anyone who has gone through a similar task and can assist me in
> meeting this request? I am running ADSM V3.1.1.5 on AIX 4.2 with STK
> 9710.
>
> All suggestions are greatly appreciated.
>
> Thanks,
> Naveed.
|
