Well, it took some time convincing Level 2 support, but IBM has opened APAR IC43086 for this behavior! So, in the future we don't have to run the SQL statement down below anymore. Good thing, because it runs for 9 hours in my shop! A nasty side affect is that it puts a lock on your storage pool which causes all storage pool update commands to hang until the command has finished!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 22:58 To: [EMAIL PROTECTED] Cc: Loon, E.J. van - SPLXM Subject: Re: Weird tape utilization 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 ********************************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **********************************************************************
