ADSM-L

Re: Weird tape utilization

2004-09-08 16:57:39
Subject: Re: Weird tape utilization
From: Neil Schofield <neil.schofield AT YORKSHIREWATER.CO DOT UK>
Date: Wed, 8 Sep 2004 21:58:02 +0100
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
<Prev in Thread] Current Thread [Next in Thread>