No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>


To have a better experience, please upgrade your IE browser.


FAQ-How to Display or Modify the Global Configuration of the Current Database Server by Running the sp_configure Command

Publication Date:  2012-07-25 Views:  69 Downloads:  0
Issue Description
How to display or modify the global configuration of the current database server by running the sp_configure command? 
Alarm Information
Handling Process
Both the database and configuration file of the Sybase contain the server configuration as follows:
Global configuration system table: sysconfigures/syscurconfigs
Configuration file: the [the name of the database server].cfg file in the sybase directory
Important configuration items are shown as follows:
number of devices: indicates the maximum number of available devices of the database (excluding the devices that dump the database logs)
number of user connections: indicates the maximum number of user connections (the number of user connections does not indicates the maximum number of processes because the maximum number of processes also depends on other system activities)
allow updates to system tables: allows updates to system tables
max online engines: indicates the maximum online engines
min online engines: indicates the minimum online engines
number of locks: indicates the number of locks
lock scheme: indicates the lock scheme
total memory: indicates the total memory
print recovery information: determines the printing information of the Sybase during the recovery of databases
recovery interval in minutes: indicates the maximum interval for recovering each database when configuring the system fails (unit: minute)
deadlock checking period: specifies the minimum period of the Sybase before starting the deadlock checking for a process that waits to release locks (unit: ms)
deadlock retries: indicates the count of deadlock retries of a transaction when the transaction is influenced by the deadlock (if the deadlock retry fails several times, the transaction is terminated)
allow remote access: allows communication access between the remote server and the client
The related command is as follows:
sp_displaylevel ‘username’ [,‘basic’|‘ingermediate’|‘conprehensive’] //to set or display the display level of the configuration item of a user
For example:
To display all the configuration items, run the following command:
To allow updates to system tables, run the following command:
sp_configure‘allow updates to system tables’,1
To display the number of locks, run the following command:
sp_configure ‘number of locks’
To display the configuration information about the memory group, run the following command:
sp_configure ‘memory’ 
Root Cause