Changing configuration options at runtime

While an instance is running, you can us sp_configure to update server configuration options. If an option changes, Adaptive Server automatically updates the master configuration file, increments the version number, updates the sysconfigures table, and instructs all instances to dump a new copy of the configuration file.

When using sp_configure with the Cluster Edition:

If an instance is not running during the configuration process, its configuration file and version number are not updated. You can either let Adaptive Server detect this when the instance starts (see “If the version numbers do not match at start-up”), or you can check the version number and dump a new copy from the quorum device:

qrmutil --quorum-dev=/dev/raw/raw101 --ase-config-version
qrmutil --quorum-dev=/dev/raw/raw101 --ase-config-extract=mycluster.cfg