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:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Tuesday, June 21, 2005 11:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: BackupStgpool preparation ==> On Mon, 20 Jun 2005 08:20:30 -0500, "Stapleton, Mark" <[EMAIL PROTECTED]> 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
