Geoff Allen wrote:
>I've currently been trying to find bottlenecks in our database. When
>we do a restore from a rather large filesystem (about 25,000 home
>directories at the top level), our ADSM server thrashes the db disks
>for a long time (20-40 minutes). During this time, the client appears
>hung (won't redraw in X, etc.). Eventually, the server finishes
>building its list, and the restore completes quickly (appears limited
>only by the ability of the tape library to mount and unmount tapes).

My first impression is that the symptoms do not necessarily point to DB
layout. Have you specified a DIRMC for this environment? I have found that
the DIRMC is important to avoid this thrashing and mounting of tapes as the
server re-assembles the directory structure. With a management class for
DIRMC, the directory structure is quickly put together. Especially if it is
all on disk. I recommend having a look at this.

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/