Re: BackupStgpool preparation
2005-06-21 13:39:20
If you want a query, you can just use a query (my resident DBA gets
credit for constructing this one):
select sum(case when q.pooltype = 'PRIMARY' then o.num_files else
-o.num_files end) as net_files from occupancy o, stgpools q
where o.stgpool_name = q.stgpool_name and q.pooltype in( 'PRIMARY',
'COPY' )
If the result is non-zero, they aren't up to date.
You can create variations on this theme to check one pool pair at a
time, if that is more appropriate for you.
I actually set this up as a rule in the Custom Summary for TOR, so a
non-zero result gets highlighted as "needs attention"!
Wanda Prather
"I/O, I/O, It's all about I/O" -(me)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Allen S. Rout
Sent: Tuesday, June 21, 2005 11:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: BackupStgpool preparation
==> On Mon, 20 Jun 2005 08:20:30 -0500, "Stapleton, Mark"
<mark.stapleton AT BERBEE DOT COM> said:
> backup stg pool1 pool2 preview=yes
So, I was wondering:
How do you folks deal with the desire to automatically answer the
question
"Are my copy pools up to date"
?
In order to automate the above-quoted query, it is necessary that the
logged-in ID have storage authority on the pools in question. This
makes it
(in my opinion) a dangerous ID to have its' password sitting around in
plaintext somewhere on disk.
- Allen S. Rout
|
|
|