Schema move in 9.1E

[Mokash]

Hi All,

Can someone tell me whethver Progress 9.1E supports schema move. i.e. whether the command proutil -C mvsch is available in 9.1E or not?
If not, then how schema move could be possible in 9.1E?


Thanks in advance.

 

[TomBascom]

Hi All,

Can someone tell me whethver Progress 9.1E supports schema move. i.e. whether the command proutil -C mvsch is available in 9.1E or not?
If not, then how schema move could be possible in 9.1E?


Thanks in advance.

9.1E is only ancient and obsolete. It is supported (sort of) but you really ought to be thinking of upgrading.

According to the Progress Knowledge Center is in v9.1D and onward. You could always try it on a test db (like sports2000) and see.

Using mvsch is a quick way to move the schema (so it is better than nothing) but your data is still stuck in an area that probably doesn't have a reasonable rows-per-block setting (it will be either 32 or 64 depending on db block size) and, if you're on OE10, it will be a type1 area rather than a type 2 area.

Generally speaking I would dump & load to get storage areas realigned. You could also do it with individual table moves but that is 1) a lot of work 2) will perform very poorly if the tables are anything but trivial and 3) will leave the schema area very large but mostly empty when you are done.