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.
By making your changes from the configuration file, you can:
Replicate a specific configuration across multiple servers by using the same configuration file.
Use a configuration file as a baseline for testing configuration values on your server.
Use a configuration file to perform validation checking on parameter values before actually setting the values.
Create multiple configuration files and switch between them as your resource needs change.
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”.
