Lists configuration parameters for Adaptive Server, including default values in Sybase Control
Center.
Sybase Control Center provides these configuration parameters on Adaptive Server:
-
attempts_reopen_con – Changes the number of times Sybase Control Center tries to reopen a broken JDBC connection to Adaptive Server. The default value is 5. This parameter only tries to re-establish broken connections—it does not control retries when a first attempt to connect to the server fails.
-
time_between_reattempts – Changes the interval (in seconds) between successive attempts to reopen a broken JDBC connection. The default value is 6. This parameter only tries to re-establish broken connections—it does not control retries when a first attempt to connect to the server fails.
-
revalidation_frequency – Changes the interval (in hours) between refreshes of the list of monitored objects in the Sybase Control Center repository.
The repository stores a list of the caches, devices, engines, and segments for all monitored Adaptive Servers. Sybase Control Center does not collect statistics for objects unless they are listed in the repository. The revalidation_frequency parameter controls how often Sybase Control Center refreshes (revalidates) the list of objects associated with each monitored server. The default value is 24.
-
jdbc_internal_query_timeout – Changes the time interval (in seconds) for JDBC internal queries to execute
before they time out. The default value is 15. This prevents server connection attempts
and other operations from hanging when resources on the server
have been exhausted. You may want to modify this if your ASE server is up, but performance is so slow that the ASEMAP agent fails to successfully establish a connection to the server. This failure usually indicates a configuration problem on the ASE server and not in the SCC ASEMAP component. Sybase recommends that you contact Sybase Customer Support to determine the cause of connection problems before modifying this parameter.
-
query_timeout
– The default
query timeout for any statements created on this connection. The default value is 30 seconds.
-
query_timeout_spaceused
– The query timeout for sp_spaceused, which is used to determine the space usage parameters for a database. The default value is 180 secs,
Note: If the parameter value is changed, the Sybase Control Center server must be shutdown and restarted.