SQLHELPER_DB_INSTANCE_COUNT (Parameter)

Parameter: SQLHELPER_DB_INSTANCE_COUNT

Definition

The number of Core Database instances that can be used by the rater instances of the SAP CC system

Description and Use

This system parameter specifies the number of SAP CC Core Database instances that the rater instances can connect to when a multiple instances database system (like Oracle RAC or IBM DB2 pureScale) is available within the landscape for failover and high availability purposes.

To be relevant, the value must be superior to 2 and the number of rater instances must be a multiple of the SQLHELPER_DB_INSTANCE_COUNT parameter.

Examples

Your system landscape includes two Core Database instances to manage failover and load balancing. Set up SQLHELPER_DB_INSTANCE_COUNT to 2 and if N corresponds to the number of rater instances of the SAP CC system:

The N/2 first instances will connect to the first instance of the database system. Set up the JDBC URI of this instance by changing the SQLHELPER_JDBC_URI_DBI1 parameter.
The other N/2 rater instances will connect to the second database instance. Set up the JDBC URI of this instance by changing the SQLHELPER_JDBC_URI_DBI2 parameter.

Consult the SAP CC Sizing and Performance Tuning Guide for more information and user assistance.

Additional Information

Consult the SAP CC Application Help (aka SAP CC Library) for more information about high availability feature and about high volume management feature.

Technical Details

For more information, consult this section.

Name

SQLHELPER_DB_INSTANCE_COUNT

The number of Core Database instances that can be used by the rater instances of the SAP CC system

Category Parameter

Type Integer

Access (RO/RW)

RW(-): Dynamic Read / Static Write

An immediate change is not possible. For a deferred and permanent change, use the set command of the Admin+ user interface to change the parameter value for a specific type of instance in the SAP CC Core Server system. A restart is needed for permanent changes.

Groups

Backends: Database Management Settings

Instance Types

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

rater, updater, guider, bulkloader, taxer, dispatcher

Default Values (Factory Settings)

The predefined default values are:

Instance Type	Value
Rater	`0`
Updater	`0`
Guider	`0`
Bulkloader	`0`
Taxer	`0`
Dispatcher	`0`

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.