Backends: Database Management Settings

Definition

System configuration settings that relate to the back-end database management (user, URI, properties)

• Description
• Setting up or viewing system parameters of this group

Description

This group includes all the system parameters concerning the back-end database management. If Oracle is the RDBMS of your SAP CC back-end database, consider also the Backends: Oracle Database Management Settings parameter group.

Scope	Core Database		Session Database
JDBC	SQLHELPER_JDBC_PROPERTIES		RATING_SESSION_SQLHELPER_JDBC_PROPERTIES
Multi-instance database	SQLHELPER_DB_INSTANCE_COUNT SQLHELPER_JDBC_URI_DBI1		RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT RATING_SESSION_SQLHELPER_JDBC_URI_DBI1
Mono-instance database	SQLHELPER_JDBC_URI		Not applicable
Connection	SQLHELPER_CONNECTION_COUNT SQLHELPER_CONNECTION_HEARTBEAT SQLHELPER_RECONNECT_ATTEMPTS SQLHELPER_RECONNECT_INTERVAL		RATING_SESSION_SQLHELPER_CONNECTION_COUNT RATING_SESSION_SQLHELPER_CONNECTION_HEARTBEAT RATING_SESSION_SQLHELPER_RECONNECT_ATTEMPTS RATING_SESSION_SQLHELPER_RECONNECT_INTERVAL
SQL request statements	SQLHELPER_STATEMENT_CACHE_SIZE		RATING_SESSION_SQLHELPER_STATEMENT_CACHE_SIZE
SAP user	SQLHELPER_LOGIN SQLHELPER_PASSWORD		RATING_SESSION_SQLHELPER_LOGIN RATING_SESSION_SQLHELPER_PASSWORD

Setting Up or Viewing System Parameters

You can set up or view the following system parameters that are available for different instance types in the running SAP CC Core Server system.

Parameter		Definition
ORACLE_COMMIT_WRITE		The commit option used within internal stateful operations performed on the Core Database
ORACLE_RATING_SESSION_COMMIT_WRITE		The commit option used within internal stateful operations performed on the Session Database
RATING_SESSION_SQLHELPER_CONNECTION_COUNT		The total number of connections to open on an instance of the Session Database
RATING_SESSION_SQLHELPER_CONNECTION_HEARTBEAT		The frequency (in seconds) of heartbeat operations sent to the Session Database
RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT		The number of Session Database instances that can be used by the rater instances of the SAP CC system
RATING_SESSION_SQLHELPER_DB_TIMEOUT		The frequency (in seconds) of ping operations sent to the Session Database
RATING_SESSION_SQLHELPER_JDBC_PROPERTIES		The properties used to connect to the Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI1		The JDBC URI to connect to the first instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI10		The JDBC URI to connect to the tenth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI11		The JDBC URI to connect to the eleventh instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI12		The JDBC URI to connect to the twelfth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI2		The JDBC URI to connect to the second instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI3		The JDBC URI to connect to the third instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI4		The JDBC URI to connect to the fourth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI5		The JDBC URI to connect to the fifth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI6		The JDBC URI to connect to the sixth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI7		The JDBC URI to connect to the seventh instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI8		The JDBC URI to connect to the eighth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI9		The JDBC URI to connect to the ninth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_LOGIN		The logon used to connect to the Session Database system
RATING_SESSION_SQLHELPER_MAX_REDO		The maximum number of redo attempts when a deadlock occurs on the Session Database
RATING_SESSION_SQLHELPER_PASSWORD		The password used to connect to the Session Database system
RATING_SESSION_SQLHELPER_RECONNECT_ATTEMPTS		The maximum number of connection attempts made after a connection to the Session Database has been lost
RATING_SESSION_SQLHELPER_RECONNECT_INTERVAL		The time period in seconds between reconnection attempts after a connection to the Session Database is lost
RATING_SESSION_SQLHELPER_STATEMENT_CACHE_SIZE		The size of the SQL request statement cache for the Session Database
SQLHELPER_CONNECTION_COUNT		The total number of connections to open on an instance of the Core Database
SQLHELPER_CONNECTION_HEARTBEAT		The frequency (in seconds) of heartbeat operations sent to the Core Database system
SQLHELPER_DB_INSTANCE_COUNT		The number of Core Database instances that can be used by the rater instances of the SAP CC system
SQLHELPER_DB_TIMEOUT		The frequency (in seconds) of ping operations sent to the Core Database system
SQLHELPER_ID_INTERVAL		The size of the pool of unique identifiers used to identify the objects into the database
SQLHELPER_JDBC_PROPERTIES		The properties used to connect to the Core Database system
SQLHELPER_JDBC_URI		The JDBC URI(s) to connect to the database systems
SQLHELPER_JDBC_URI_DBI1		The JDBC URI to connect to the first instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI10		The JDBC URI to connect to the tenth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI11		The JDBC URI to connect to the eleventh instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI12		The JDBC URI to connect to the twelfth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI2		The JDBC URI to connect to the second instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI3		The JDBC URI to connect to the third instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI4		The JDBC URI to connect to the fourth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI5		The JDBC URI to connect to the fifth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI6		The JDBC URI to connect to the sixth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI7		The JDBC URI to connect to the seventh instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI8		The JDBC URI to connect to the eighth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI9		The JDBC URI to connect to the ninth instance of a multi-instance Core Database system
SQLHELPER_LOGIN		The logon used to connect to the Core Database system
SQLHELPER_MAX_REDO		The maximum number of redo attempts when a deadlock occurs on the Core Database
SQLHELPER_PASSWORD		The password used to connect to the Core Database system
SQLHELPER_RECONNECT_ATTEMPTS		The maximum number of connection attempts made after a connection to the Core Database has been lost
SQLHELPER_RECONNECT_INTERVAL		The time period in seconds between reconnection attempts after a connection to the Core Database is lost
SQLHELPER_STATEMENT_CACHE_SIZE		The size of the SQL request statement cache for the Core Database