Ann,

First, make certain our expiration is running and completing without any
problems.  A tape with problems can stop expiration every day and your DB
will balloon up.

To see which client(s) are hogging the all the storage, do a query
occupancy.  This will break down the amount of data stored and amount of
files stored for each client.  The amount of files will tell you how many
DB records they are running.  We ran this and found a client who was
running an archive daily.  We were happy to serve them, but when we pointed
out that any excessive storage requirements may be charged to their
project, their requirements changed rapidly.

Are you v2 or v3.  V3 should help, I am led to believe.

Dan T.


----------
> From: Ann Courchaine <acourcha AT CSC DOT COM>
> From: Ann Courchaine <acourcha AT CSC DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: db sizing
> Date: Monday, February 09, 1998 1:13 PM
>
> Hi adsmer's,
>      I have had many problems with correctly sizing the ADSM db. It just
> keeps getting larger & larger and I keep backing it up over & over. Does
it
> ever stop growing? Is there some process I need to do like export import?
>
> Ann Courchaine