Re: AUDIT DB
2000-01-28 10:16:49
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
|
|
|