I only ask as there was an SQL query that could do this some tim ago and i
can't remember where i saw it.
I don't suspect any problem i was just curious!!.
Thanks,
Kuli.
Kulbinder Toora
01384 296191 x3498
e-mail - Kulbinder.toora AT meb.co DOT uk
NPEC (National Power Energy Company)
> -----Original Message-----
> From: Bill Colwell [SMTP:bcolwell AT DRAPER DOT COM]
> Sent: Wednesday, September 01, 1999 4:08 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: differences between storagepools and copypools.
>
> I can't think of a way to find out what is in a copypool but not in a
> primarypool
> since this can't happen by definition. If it did, you would have a
> seriously
> corrupted server.
>
> To get gross counts, do 'q occ stg=<primarypool_name>' for all your
> primary
> pools and sum the results. Then do the same for your copy pool, I assume
> you
> have just one. The sum of number of files in the primary pools should be
> very close
> and larger than the number of files in the copypool.
>
> Would you like to see the numbers exactly equal? If you can
> find an hour or so when no files are entering or leaving the server, that
> is no client
> sessions and no expiration process, do 'backup stg' commands for all your
> primary pools, then do the 'q occ' commands. The numbers should be equal.
> That's a nice warm & fuzzy feeling. But if they still aren't equal, you
> may have a serious database problem.
>
> Why are you asking? Are you looking for the warm&fuzzy or do you suspect
> trouble?
>
>
> --
> --------------------------
> Bill Colwell
> C. S. Draper Lab
> Cambridge, Ma.
> bcolwell AT draper DOT com
> --------------------------
>
> In <9F07443487F5D1118DB6000629C138A12BA6F6@exchange01>, on 09/01/99
> at 03:38 PM, "Toora, Kuli" <kulbinder.toora AT MEB.CO DOT UK> said:
>
> >Hello folks,
>
> >I have a question:
>
> >Does anyone know how i can interogate my storage pools and my copy pools
> to
> >pick out any differences.
> >More explicitly how can i find out what files /filespaces etc are in the
> >copypool and not in the storagepool and vice versa.
>
> >Thanks,
>
> >Kuli.
>
> >Kulbinder Toora
> >01384 296191 x3498
> >e-mail - Kulbinder.toora AT meb.co DOT uk
> >NPEC (National Power Energy Company)
>
> >================================================================
>
> >This outgoing e-mail (and any attachments) has been checked
> >(using Sophos SAVI 3.24 and Dr Solomon's v7.96) before leaving us
> >(UK 01384 296191), and has been found to be clean from any virus
> infection.
>
> >Virus queries - PC Tech Support (09 3521)
> >E-mail system - External Postmaster (09 3673).
>
> >================================================================
>
> ================================================================
>
> This incoming e-mail (and any attachments) has been checked at MEB,
> and has been found to be clean from any virus infection
> (using Sophos SAVI 3.24 and Dr Solomon's v7.96).
>
> Virus queries - Tech Support (09 3521)
> E-mail system - External Postmaster (09 3673)
>
> ================================================================
================================================================
This outgoing e-mail (and any attachments) has been checked
(using Sophos SAVI 3.24 and Dr Solomon's v7.96) before leaving us
(UK 01384 296191), and has been found to be clean from any virus infection.
Virus queries - PC Tech Support (09 3521)
E-mail system - External Postmaster (09 3673).
================================================================
|
