You can configure Adaptive Server either interactively, by using sp_configure as described above, or noninteractively, by instructing Adaptive Server to read values from an edited or restored version of the configuration file.
The benefits of using configuration files include:
You can replicate a specific configuration across multiple servers by using the same configuration file.
You can use a configuration file as a baseline for testing configuration values on your server.
You can use a configuration file to do validation checking on parameter values before actually setting the values.
You can create multiple configuration files and switch between them as your resource needs change.
You can make a copy of the configuration file using sp_configure with the parameter “configuration file” and then edit the file at the operating system level. Then, you can use sp_configure with the parameter “configuration file” to instruct Adaptive Server to read values from the edited file. Or you can specify the name of the configuration file at start-up.
For information on editing the file, see “Editing the configuration file”. For information on specifying the name of the configuration file at start-up, see “Starting Adaptive Server with a configuration file”.
