Re: Database Size

Bill,

I had a problem with exploding database size so I ran this sql against the
database

select node_name, filespace_name, hl_name, count(*)
     from backups
     group by node_name,filespace_name,hl_name
     order by 4 desc

This will show the source directories with the most backup files. Look for much
larger numbers of files than you would expect from the normal size of the
directory.
I then used MS-Access to look at the backup files from that directory in more
detail.

 In my case, I found a directory that was being filled by "temporary" files with
distinct, machine-generated names.  These were being deleted nightly, but
*after* the backup was run.  I had 130,000 of these when I discovered them,
mostly 2000 bytes each . Dealing with them dropped my database size by 10% (of
900MB)

Regards

Steve Harris
AIX/ADSM/Oracle/HACMP Guy
The Wesley Hospital, Brisbane Australia









W_Bill Rose <W_Bill.Rose.B AT BAYER DOT COM> on 07/03/2000 05:45:44

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>








 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: Steve Harris/Wesley)



 Subject: Re: Database Size



Fax to:




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
>


===========================================
This email message has been swept by MIMESweeper





===========================================
This email message has been swept by MIMESweeper