Reference to parameters you can set in the Sybase Control Center for
Adaptive Server configuration file.
Note: Sybase recommends that you consult Sybase technical support before setting any
parameters in the configuration file.
Sybase Control Center for Adaptive
Server provides these configuration parameters:
-
attempts_reopen_con – the number of times
SCC tries to reopen a broken JDBC connection to Adaptive Server. This parameter
only affects re-establishing broken connections—it does not control retries when
a first attempt to connect to the server fails.
Note: SCC does not declare a
server stopped (down) until all the retries called for by
attempts_reopen_con have failed.
Default:
5
-
time_between_reattempts – the interval (in
seconds) between successive attempts to reopen a broken JDBC connection. This
parameter only tries to re-establish broken connections—it does not control
retries when a first attempt to connect to the server fails.
Default:
6
-
revalidation_frequency – 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. SCC does
not collect statistics for objects unless they are listed in the repository.
The revalidation_frequency parameter controls how often SCC refreshes
(revalidates) the list of objects associated with each monitored server.
Default: 24
-
jdbc_internal_query_timeout – the time
interval (in seconds) for JDBC internal queries to execute before they time out.
The timeout prevents server connection attempts and other operations from
hanging when Adaptive Server resources have been exhausted. Consider modifying
this value if Adaptive Server is running, but performance is so slow that the
SCC agent fails to establish a connection to the server. This failure usually
indicates a configuration problem on Adaptive Server and not in SCC for Adaptive
Server. Contact Sybase technical support for help in determining the cause of
connection problems before modifying this parameter.
Default: 15
-
query_timeout – the default query timeout
(in seconds) for any statements created on this connection.
Default: 600
-
query_timeout_spaceused – the query timeout
(in seconds) for sp_spaceused, which
determines the space usage parameters for a database.
Default: 180
Note: Changes to parameter values do not take effect until SCC
restarts.