VST table _StatBase has disappeared in 12.1 - OpenEdge RDBMS - Forum

Posted by gdb390 on 13-Jan-2020 14:39

Hi,

It seems that the VST table _StatBase has disappeared in 12.1.

Has this been replaced by something else ?

We used that for setting _indexbase / _TableBase to different value ...

Or is it enough to work with the -tablerangesize / -indexrangesize start-up parameters ?

Kind regards

Gerd

Posted by Richard Banville on 13-Jan-2020 15:07

As part of OpenEdge 12.0, ths _StatBase vst table has been removed. Its functionality is replaced by the _DbParams table.

find _dbparams where _dbparame-name = "-basetable".

Update _dbparams-value. (NOTE: this is always a character value so setting it to 100 is: assign _dbparams-value = "100".)

If successful, in the .lg file you will see the following:

(17554) Starting table number for statistics range (-basetable): <n>

The same is supported for index and lobs.

Posted by George Potemkin on 14-Jan-2020 14:28

> If successful, in the .lg file you will see the following:

And if update was not successful we will not get an error.

Are there any ways to check the failure other than to re-read the updated value?

This thread is closed