proutil -C dbgrow

Posted by Stefan Marquardt on 29-Feb-2016 02:58

There is a bigrow available.
I don't like to have fixed extent and want to use only variable extents to avoid problems (extent full)
And I don't like to use fixed extent and one variable, then I need to watch it all the time, not good for a 24h system.
But how to preformat a db variable extent (online) to move the formatting of extents in times with low I/O?

Posted by Dmitri Levin on 04-Mar-2016 14:46

I believe George answered the question.

There is no "dbgrow" utility in Progress while in Oracle one can do

alter database datafile '<your_extent_full_path>' resize  <size>;

Your best bet is to create one variable extent per area and just monitor the space on the file system.

All Replies

Posted by George Potemkin on 29-Feb-2016 03:08

You will not get the essential benefits from the "dbgrow" utility because data extents are growing too slow. And while one process is adding new data cluster to a variable extent the other processes are not blocked and they can continue their db updates at the same time.

Posted by Dmitri Levin on 04-Mar-2016 14:46

I believe George answered the question.

There is no "dbgrow" utility in Progress while in Oracle one can do

alter database datafile '<your_extent_full_path>' resize  <size>;

Your best bet is to create one variable extent per area and just monitor the space on the file system.

This thread is closed