RATING_SESSION_SQLHELPER_CONNECTION

Parameter: RATING_SESSION_SQLHELPER_CONNECTION_COUNT

Definition

The total number of connections to open on an instance of the Session Database

Description and Use

This system parameter specifies the total number of connections to open on an instance of the Session Database. If the Session Database is multi-instances, the overall number of opened connections is a multiple of this total number.

The value of this parameter must be correlated to the total number of threads running in each instance of the SAP CC system. If the number of connections to the Session Database is too small compared to the total number of threads running in the instance of the SAP CC system, the threads are not able to render the service because they do not find any available connection to perform their database requests.

Recommendation

SAP recommends that you set up the parameter value to the total number of threads used by the instance of the SAP CC system. But if it is not possible (too many threads in comparison with the Session Database capabilities), SAP recommends that you reduce the number of threads for the least used services.

Syntax and Constraints

Defined Constraints

The SAP CC Core Server system verifies the following constraints:

Instance Type	Constraint
Rater instances	The parameter must be greater than or equal to ((RATING_SESSION_SELECT_POOL_SIZE + RATING_SESSION_UPDATE_POOL_SIZE + CACHE_WARMUP_THREAD_COUNT) when RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT is enabled; 0 otherwise ) . The parameter must be greater than or equal to (1 when RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT is enabled; 0 otherwise ) .

Technical Details

For more information, consult this section.

Name

RATING_SESSION_SQLHELPER_CONNECTION_COUNT

The total number of connections to open on an instance of the Session Database

Category Parameter

Type Integer

Access (RO/RW)

RW(+): Dynamic Read / Static and Dynamic Write

An immediate change is possible but is temporary. When it is relevant, change the permanent settings used by the SAP CC Core Server system when it restarts.

Use the Admin+ user interface to change the runtime values or the permanent values of this system parameter in an instance of the SAP CC Core Server system or in multiple instances.

Groups

Backends: Database Management Settings

Instance Type

This system parameter is only available in the following type of instances in a running SAP CC Core Server system:

rater

Default Value (Factory Settings)

The predefined default value is:

Instance Type	Value
Rater	`8`

You can use a default value to reset the runtime value or the restart value (persistent) in the Admin+ user interface.

Note

A default value is part of the factory settings of the SAP CC Core Server systems. It differs from the original value set during the installation or after the Customizing activities.

In Admin+, you can reset a parameter value to this default value, but it is not recommended:

This value may differ from the original value set during the installation of your SAP CC system.
Note that it may also differ from the value defined by the implementation project team and set during the Implementation Phase of the integration project.

Verify the values in your running SAP CC systems before to use the reset command.

Constraints

The SAP CC system checks the following constraints:

Rater instances

The parameter must be greater than or equal to ((RATING_SESSION_SELECT_POOL_SIZE + RATING_SESSION_UPDATE_POOL_SIZE + CACHE_WARMUP_THREAD_COUNT) when RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT is enabled; 0 otherwise ) .
The parameter must be greater than or equal to (1 when RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT is enabled; 0 otherwise ) .