Setting?  Your copy pool - "query copy * active *"

On Mon, 6 Mar 2000, W_Bill Rose wrote:

> Sorry I didn't mention we are using   Server Version 3, Release 1, Level 2.20
>
> By the way, what settings are you asking about? How do view what they are?
>
> Thanks
>
>
>
>
>
> "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us" on 03/06/2000 
> 01:35:20
> PM
> Please respond to "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= 
> /C=us" @ X400
> To: "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us"@X400
> cc:
> Subject: Re: Database Size
>
> Be sure you are not on the sever levels 3.1.2.3x, as one of these levels
> failed to expire properly.  Anything that will reduce the number of retained
> objects will reduce the db.  What are your settings?
>
> Also, you may have backups of dead file spaces the can be deleted.  Try a
> query like following and see what hasn't been backed up for a long time.
> Then see if the client still needs it.
>
>   select node_name,filespace_name,filespace_type,cast(backup_end as DATE) -
>   as "LAST BKUP" from filespaces where cast(backup_end as DATE)<'2000-01-01'
>
>
> On Mon, 6 Mar 2000, W_Bill Rose wrote:
>
> > Could someone please tell me if there is a way to reclaim space in the
> > Database? Our database has grown to 30GB of diskspace and is 87% utilized. 
> > We
> > do an EXPIRE INVENTORY operation weekly and we have not added any new 
> > clients
> > in over 4 months. Are there some Server settings or setting adjustments we
> > could make to be able to reclaim some space in the database?
> >
> > As always, thanks in advance for your help.
> >
> > Bill
> >
>