Adjust startup parameters using promon or _DbParams VST

pinne65

Member
Ran into a pickle - added - SQLWidthUpdate ON in on a 11.6 database and having some performance issues.

Reading that it should be possible to update the parameter with the database online: Progress Documentation using either promon or _DbParams VST. I'm not seeing option 16 - adjust startup parameters under R&D / 4 in promon.

The last option on the menu is 11. Does anyone know in which version this was introduced?

If it's not available, is it still possible to update _DbParams, and if so, how to go about it - haven't found any good docs on it yet ?


Querying the DBParams table seems to indicate this paramater can't be modified???

DbParams-Id DbParams-Name DbParams-Value DbParams-dtype
DbParams-Desc
DbParams-Msg-Num Default value Modifiable DbParams-Misc
──────────────────────────────────────────────────────────────────────
95 -SQLTempStorePag 0 4
Size [1K byte units] of SQL Server temp table data page (-SQLTem
10031 yes no ?
96 -SQLTruncateTooL OFF 1
Authorized data truncation (-SQLTruncateTooLarge): OFF (17955)
17955 yes no ?
97 -SQLWidthUpdate OFF 1
SQL Autonomous Schema Update (-SQLWidthUpdate): OFF (18156)
18156 yes no ?




(We can't upgrade Progress to a later version because of the application that's running)
 
Last edited:

Rob Fitzpatrick

ProgressTalk.com Sponsor
Reading that it should be possible to update the parameter with the database online: Progress Documentation using either promon or _DbParams VST.
You are looking at the 12.2 documentation, so you are seeing promon options you don't have in 11.6.

In 11.6 you should have an _dbparams VST, though it is possible that you don't if your database was created with an earlier DLC and you haven't run proutil dbname -C updatevst since moving to 11.6.

You don't have the ability to adjust all adjustable broker parameters in promon. But you can adjust some values programmatically if you have the _dbparams VST. That said, -SQLWidthUpdate is a parameter that you can't adjust online in your release. You will have to stop the database, adjust the broker parameter, and restart.

We can't upgrade Progress to a later version because of the application that's running
I'd be very surprised if there is a valid technical reason why you can't successfully upgrade to 11.7. At least you would be on a non-retired release.
 
Top