The only "weight loss program" for the TSM DB, other than getting rid of
unneeded stuff, is expiration. Make sure it is started daily, and let it
run a long time. I start it as soon as DB backup ends, and then cancel
it with CANCEL EXPIRATION just before the next DB backup is started.

With my 200GB database, tuning for expiration is a prime consideration.
Either DB backup or expiration is always running.

Eventually, there will be no other choice except to add a volume and
EXTEND DB. If you're almost at 100% now, you most likely have to do that
first, and then you can fiddle around with increasing expiration.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu


On Thu, 20 Apr 2006, Richard Sims wrote:

>On Apr 20, 2006, at 9:49 AM, Norita binti Hassan wrote:
>
>> My DB is nearly 100% full . Can I use the REDUCE command to solve this
>> problem rather than extend the Db.
>
>The REDuce DB command is not a weight loss program for the TSM
>database, but rather a retraction of the amount of space it may
>consume within its allotment.
>
>You either have to get rid of unneeded stuff in your database (e.g.,
>obsolete filespaces) or extend it. We all have to extend our
>databases, due to inevitable growth in demand.
>
>   Richard Sims
>