Reference to parameters you can set in the SAP Control Center for the
SAP ASE configuration file.
Note: SAP recommends that you consult SAP technical support before
setting any parameters in the configuration file.
SAP Control Center for SAP
ASE provides these configuration parameters:
-
attempts_reopen_con – the number of times
SCC tries to reopen a broken JDBC connection to SAP ASE. 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 SAP Control
Center repository.
The repository stores a list of the caches,
devices, engines, and segments for all monitored serverss. 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 server resources have been exhausted. Consider modifying this value
if SAP ASE 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 SAP ASE and not in SCC. Contact SAP 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.