ADSM-L

Re: Can't reduce database

1997-09-30 03:56:35
Subject: Re: Can't reduce database
From: Sheelagh Treweek <sheelagh.treweek AT COMPUTING-SERVICES.OXFORD.AC DOT UK>
Date: Tue, 30 Sep 1997 08:56:35 +0100
Trevor,

There is not a mechanism to do what you want; you can only remove whole
empty pages.  So you can reduce the 1900 mb as you say, but there is no way
to tell ADSM that you want to consolidate the information there into fewer
pages.  In general I understand that doing a DSMSERV DUMPDB and then a
DSMSERV LOADDB might even grow your database but as you have deleted so much
I would say it's worth a try.  I would make sure that I had a BACKUP DB that
could be RESTOREd if the end result wasn't as small as needed.  You would
need to get the DSSMSERV INSTALL sized with the number of dbvols you want.

For 8GB it might take a couple of hours to do the LOADDB - longer than the
DUMPDB (which needs to be done on a quiet system).  Also, I think there is an
option on LOADDB to reduce the number of messages it puts out while in progess
(server option file STAtusmsgcnt xxx ...  it's in the server README).

Regards, Sheelagh

------------------------------------------------------------------------------
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Oxford University Computing Services     Tel:   +44 (0)1865 273205
13 Banbury Road, Oxford, OX2 6NN, UK     Fax:   +44 (0)1865 273275
------------------------------------------------------------------------------
> From owner-adsm-l AT VM.MARIST DOT EDU  Tue Sep 30 05:56:34 1997
> From owner-adsm-l AT VM.MARIST DOT EDU  Tue Sep 30 05:56:34 1997
> From: Trevor Foley <Trevor.Foley AT BANKERSTRUST.COM DOT AU>
> Subject: Can't reduce database
>
> A few weeks back, we started deleting a large number of nodes off one of
> our ADSM servers. Before the deletion, database utilisation was in excess
> of 80% of 12gb. Now that the deletions are finished, database utilisation
> is down to less than 20%. However, the 'Maximum Reduction' only 1900 mb,
> less than 16% of the total size.
>
> Why can't I reduce the database? We need to bring it down to 8gb (2 x 2gb
> dbvolumes).
>
> Configuration details:
>
> - AIX 4.2.1
> - System R50, 256mb memory
> - ADSM server 2.1.5.13
>
>
> Trevor
>
<Prev in Thread] Current Thread [Next in Thread>