moving indexes

[geoffconnolly]

Hi
we are running progress version 9.1d using data areas
we added a few indexes recently and forgot to assign the correct data areas
so they ended up in the schema area
we used proutil -C idxmove to rectify this
the problem is that they have increased the size of the schema area extent to half a GIG

is there anyway of compressing this file size ???


Geoff

 

[Krokodile]

use mvsch if your version of Progress supports it otherwise you'll have to get patch for it. This is the only solution for it, as far as i know from all the doc. I have read.

proutil <dbname> -C mvsch

This will move all the Data objects to the next unused storage areas.
There's a KB for this P4794, which is ok also u can get some documentation on dynaweb.progress.com thru www.peg.com.

let me know how it worked out for you.
I used it a long time ago and do know that it did help me in moving all DO to other default areas and shruk the bloated Schema area.