Parameter: SQLHELPER_DB_INSTANCE_COUNT
Definition
Description
This system parameter specifies the number of Core Database instances that the raters 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 Sizing Guidelines for more information.
Detailed Information
| Name | SQLHELPER_DB_INSTANCE_COUNT
|
|||||||||||||
| 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 |
|||||||||||||
| Group(s) | Database Management Settings | |||||||||||||
| System Instances | This system parameter is available in the following types of instances in a running SAP CC system: rater, updater, guider, bulkloader, taxer, dispatcher | |||||||||||||
| Default Values (Factory Settings) |
|
|||||||||||||
Additional Information
Consult the SAP CC Library (Application Help) for more information about high availability feature and about high volume management feature.