BI size ???

[kevin_w]

Hi,


I have cleaning out records of my database, before the db has a size of 517MB and the BI-file 17MB. Now after that i have dump some of the tables and re-load them in to the db the BI-file has over the 150MB and the db file is still the same size. Is there a way to make the BI-file and the db-file smaller ??? I'm working with progress 8.3.


Thanks

 

[Casper]

Hi,

to shrink bi: stop the database and truncate bi
--> proutil <databasename> -C truncate bi

Is there a way to make ......the db-file smaller

You have to dump all your data, make new db and reload data in new database to make the database as small as possible. (What is the reason you want the database file to be smaller?)

Regards,

Casper.

 

[kevin_w]

Hi,

to shrink bi: stop the database and truncate bi
--> proutil <databasename> -C truncate bi


You have to dump all your data, make new db and reload data in new database to make the database as small as possible. (What is the reason you want the database file to be smaller?)

Regards,

Casper.

I was just thinking it would be logical that when there are almost a few records left the db must be smaller ??

 

[kevin_w]

Ok i have truncate the bi and it's now nice and small, is there any way to do this with the db also (db before about 500 MB and still the same now)?

 

[Casper]

Hi Kevin,

If you delete records then the blocks who had data in them come on the rm chain, these are alereay formatted blocks.
Even when a data block contains no records, it does not become a FREE block

It doesn't matter if the database is bigger then you suspect, if you put data in the database now, then the blocks below the high water mark will be used until they are no more available.
The only way to get rid of this 'empty' space is to rebuild the database like I said or if you removed all the data in an area, truncate the area. But since you're on version 8 trunctae area isn't an option, so if you want to lower the high water mark, you have to rebuild the database:
dump all data, squence and values user table, make new db and load data, sequences, etc...

Regards,

Casper.