Hello,

I agree, it is best to audit all the db. BUT, the process run here for 3
days with a 7.5 GB db, under OS/390, 120 mips server.

So, I wouldn't expect only 4/5 hours! Difficult to estimate if we don't know
the processor and I/O speed of your server.

Also the percentage used in the db is an important factor for the elapsed
time.

Best regards,

                René Lambelet
                Nestec S.A. / Informatique du Centre 
                55, av. Nestlé  CH-1800 Vevey (Switzerland) 
                *+41(021) 924 3543  7 +41 (021) 924 4589  * B 133
                mail to: rene.lambelet AT nestle DOT com 

                This message is intended only for the use of the addressee
        and may contain information that is privileged and confidential.


> -----Original Message-----
> From: Mauro M. TINELLI [SMTP:Mauro.TINELLI AT ST DOT COM]
> Sent: Friday, January 28, 2000 3:57 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: AUDIT DB
> 
> Bruno,
> 
> you've got to check all the DB at once. It depends on various factors,
> CPU, Disks ... I'd say 4/5 hours.
> 
> Ciao,
> Mauro, STM
> 
> > hi,
> > since there is no documention available on AUDIT DB, I appeal to you
> guys.
> > What can I specify on the PARTITION parameter if i only want to have a
> part
> > of the db checked (tape volumes)?
> > The size of allocated db space is 3.7 GB. Usage stands at 5% (growing
> slowly
> > ....),
> > used tape volume count is 16 (DLT). Does anyone have an idea about how
> long
> > it could take to audit the database ?
> >
> > thank you for spending your time for me !
> > bruno