SQLHELPER_ID_INTERVAL (Parameter)

Parameter: SQLHELPER_ID_INTERVAL

Definition

The size of the pool of unique identifiers used to identify the objects into the database

Description and Use

When an instance creates an object, it asks the DB to indicate a correct identifier for the newly created object. Because this operation is very frequent, the database provides a pool of identifiers to the instance in order to limit DB SQL request and increase performances.

The SQLHELPER_ID_INTERVAL parameter represents the size of the pool of identifiers.

All the identifiers belonging to the pool are considered as consumed by the database. So if the instance is stopped, all the identifiers already requested and not yet used by the instance are lost.

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 1 .
Updater instances	The parameter must be greater than or equal to 1 .
Guider instances	The parameter must be greater than or equal to 1 .
Bulkloader instances	The parameter must be greater than or equal to 1 .
Taxer instances	The parameter must be greater than or equal to 1 .
Dispatcher instances	The parameter must be greater than or equal to 1 .

Technical Details

For more information, consult this section.

Name

SQLHELPER_ID_INTERVAL

The size of the pool of unique identifiers used to identify the objects into the database

Category Parameter

Type Long

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	`10000`
Updater	`10000`
Guider	`10000`
Bulkloader	`10000`
Taxer	`10000`
Dispatcher	`10000`

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 1 .
Updater instances	The parameter must be greater than or equal to 1 .
Guider instances	The parameter must be greater than or equal to 1 .
Bulkloader instances	The parameter must be greater than or equal to 1 .
Taxer instances	The parameter must be greater than or equal to 1 .
Dispatcher instances	The parameter must be greater than or equal to 1 .