Change Adaptive Server Configurations

To change configuration settings for Adaptive Server, use the Server Config utility.

You can run Server Config either by:

Selecting Server Config from within Windows, or by,
Running sp_configure from within isql. Use sp_configure to quickly and easily change single parameters and values. For more information, see sp_configure in the Reference Manual: Procedures.

Note: Adaptive Server 15.0.3 and later installers allow you to tune basic configuration settings during installation, instead of as a post installation task. See the Installation Guide.

Starting Server Config
Start the Server Config utility from the Windows Start menu. To run this utility from the Windows command prompt, run syconfig.exe.
Configuring Adaptive Server
Use Change Options from within Server Config to configure Adaptive Server.
Configuring Backup Server
Backup Server performs all Adaptive Server backup and recovery operations (dump and load).
Configuring Job Scheduler and Self Management
Job Scheduler defines and schedules database administration and maintenance tasks. Self Management is the Adaptive Server ability to monitor and adjust its state as necessary. You can create and schedule jobs for maintenance and tuning tasks to extend the Adaptive Server self-management capabilities.

Parent topic: Adaptive Server Configurations