Eric Good luck with your PMR. In the meantime, below is a script that I wrote when I realised that we were suffering the "tape leak" that Richard describes.
It works on the premise that with collocation turned on, there should only be one filling read-write volume in each storage pool per node/filespace. The select statements list the filling volumes by node for each storage pool collocated by node, and the filling volumes by filespace for each storage pool collocated by filespace. Each node/filespace should be listed only once per storage pool in the output. Scan down the output and if a node/filespace appears more than once it means you are using more tapes than necessary. In this case, pick one of the volumes (ideally the least utilised), update its access-mode to read-only and issue a MOVE DATA on it. You should see one of the other filling volumes listed be mounted as the destination. I usually run the script once a month or so. It may take a while, but is worth it for the tapes you get back. Now if only TSM could take care of this itself ... Regards Neil Schofield Yorkshire Water Services Ltd. select volumeusage.node_name, volumeusage.stgpool_name, volumeusage.volume_name from volumeusage, volumes where volumeusage.volume_name=volumes.volume_name and volumes.status='FILLING' and volumes.access='READWRITE' and volumeusage.stgpool_name in (select stgpool_name from stgpools where collocate='YES') group by volumeusage.node_name, volumeusage.stgpool_name, volumeusage.volume_name order by stgpool_name select volumeusage.node_Name, volumeusage.filespace_name, volumeusage.stgpool_name, volumeusage.volume_name from volumeusage, volumes where volumeusage.volume_name=volumes.volume_name and volumes.status ='FILLING' and volumes.access='READWRITE' and volumeusage.stgpool_name in (select stgpool_name from stgpools where collocate='FILESPACE') group by volumeusage.node_name, volumeusage.filespace_name, volumeusage.stgpool_name, volumeusage.volume_name order by stgpool_name Find out about our new Icytonic drink at http://www.yorkshirewater.com The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House Halifax Road Bradford BD6 2SZ Registered in England and Wales No 2366682
