Hi Bill -
I am way behind on the list, but I think I can help you.
First there isn't any sql I know of that will do what you want.
But, the old query content command will give you the answer, you just need
to post process the output.
The steps are
1. make a macro file of 'q con' commands for
L PROTECTED]
cc:
Subject: Re: SQL to determine what offsite volumes are needed for move
data
...
>Our tape copy pools are kept offsite. Reclamation for these pools is
>handled by leaving the TSM reclamation threshhold at 100% so that he
never
>does reclaims on his own. O
On Thu, 16 Oct 2003, Richard Sims wrote:
> >Now the problem. Some of these 'move data' processes treat the volume
> >that is being emptied as 'offsite', even though the volume has been loaded
> >into the library and its access updated to readwrite. I'm pretty sure the
> >reason for this is that
...
>Our tape copy pools are kept offsite. Reclamation for these pools is
>handled by leaving the TSM reclamation threshhold at 100% so that he never
>does reclaims on his own. On a regular basis, we run a job that queries
>the server for copy pool tapes with a reclamation threshhold greater than
Hi,
We're running TSM server 5.1.6.2 on z/OS.
One of the (many) resources we're short on is tape drives. Consequently,
I'm always looking to streamline processes that use these drives. Here's
the problem I'm currently looking at:
Our tape copy pools are kept offsite. Reclamation for these poo
