Allowed Changes to Database Options details the changes that can be made to the database options. The asterisk (*) refers to the explanatory note following the table.
Table 21. Allowed Changes to Database Options
|
Option |
Model |
Update |
File Format Conversion (No Item Changes) |
|
|---|---|---|---|---|
|
ADDRESSCHECK |
No |
No |
No |
|
|
AUDIT |
No |
No |
No |
|
|
BACKOUTTOSPT |
No |
Yes* |
Yes |
|
|
BACKUPKEYSET |
No |
Yes |
Yes |
Yes |
|
KEYCOMPARE |
No |
Yes* |
Yes |
|
|
LOCKPROGRAM |
Yes |
Yes |
Yes |
Yes |
|
OPENOLTP |
No |
Yes* |
Yes |
|
|
RDSSTORE |
No |
Yes |
Yes |
|
|
RESTART TRANSACTIONS ONLY |
No |
Yes* |
Yes |
|
|
SECURITYADMIN |
Yes |
Yes |
Yes |
Yes |
|
SENSITIVEDATA |
Yes |
Yes |
Yes |
Yes |
|
STATISTICS |
No |
Yes |
Yes |
|
|
TPSDUALUPDATE |
No |
Yes* |
Yes |
|
|
INDEPENDENTTRANS |
No |
Yes* |
Yes |
|
|
REAPPLYCOMPLETED |
No |
Yes* |
Yes |
Yes |
|
LOCKEDFILE |
No |
Yes* |
Yes |
|
|
XL |
No |
Yes |
Yes |
Yes |
Explanatory Note
Recompile the DMSUPPORT library, and if the OPENOLTP option is set, recompile the RMSUPPORT library.
