Kbase P153704: Changes made to sysprogress.systblstat by update table statistics are not retained after user discon
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Changes made to sysprogress.systblstat not retained after user disconnects
Running update statistics
FACT(s) (Environment):
Running update statistics from SQLExplorer
Disconnecting after running update statistics
Changes are retained if running via WinSQL.
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Not running commit
CAUSE:
Update table statistics not being commited to the database. By default, SQLEXplorer has AutoCommit set to false.
FIX:
Use the commit statement after the update statistics or change the AutoCommit from false to true in the SQLExplorer.properties file.
SQLEXplorer.properties file