Issue sp_configure with the Configuration File

Configure SAP ASE either interactively, by using sp_configure, or noninteractively, by instructing SAP ASE 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.

Configuration File Naming Recommendations
To work with a configuration file that has a name other than the default name, keep the server_name part of the file name, and include at least one alphabetic character in the extension (for example my_server.A001).
Read or Write the Configuration File with sp_configure
sp_configure includes syntax options for using configuration files.
Edit the Configuration File
The configuration file is an ASCII file that you can edit with any text editor that can save files in ASCII format.
Start SAP ASE Using a Configuration File
By default, SAP ASE reads the configuration file server_name.cfg in the start-up directory when it starts. If this file does not exist, it creates a new file and uses SAP ASE defaults for all values.

Parent topic: Using sp_configure