John,

my 2 cents ... I have a 25GB DB which is 50% full, I had before a 9GB DB.
I erroneously supposed to Audit-DB it. With the previous one I managed to
do it a couple of time, now after 26 hours and 135.000.000 entries, I
decided that I'm using a huge DB and I interrupted the operation at my
own risk!

My daily backup is 45 mins, it'll be 1:30 hours if it was full ... I
guess you are well over 2 hours.

So my conclusion is that 40 GB is big enough to be considered HUGE by
ADSM standard.

Thank you

Mauro, STM

> Richard Sims responded:
> >  The consensus is that when your server
> > reaches "huge" size that you subdivide into multiple servers.
>
> Thanks for the response.  When I do a Q DB, I get:
> ANR5965I Console command:  Q DB
>
>
>
> Available Assigned   Maximum   Maximum    Page     Total      Used
Pct
> Max.
>     Space Capacity Extension Reduction    Size    Usable     Pages
Util
> Pct
>      (MB)     (MB)      (MB)      (MB) (bytes)     Pages
> Util
> --------- -------- --------- --------- ------- --------- ---------
-----
> -----
> -----
>    36,764   36,764         0     4,988   4,096 9,411,584 7,912,982
84.1
> 84.1
>
>
> adsm>
>
>
> The DataBase is at 36.7GB.  Is this "huge"?
>
> John G. Talafous                         Sr. Tech. Prog/Anal
> The Timken Company                 Phone: (330)-471-3390
> P.O. Box 6927                           Fax  : (330)-471-4034
> 1835 Dueber Ave. S.W.
> Canton, Ohio USA  44706-0927
> talafous AT timken DOT com                  http://www.timken.com/