Parameter: SQLHELPER_ID_INTERVAL

Definition

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

Description

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.

Detailed Information

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 system. A restart is needed for permanent changes.
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)	rater 10000 updater 10000 guider 10000 bulkLoader 10000 taxer 10000 dispatcher 10000
Constraint(s)	The SAP CC system checks the following constraints: rater The parameter must be greater than or equal to 1 updater The parameter must be greater than or equal to 1 guider The parameter must be greater than or equal to 1 bulkLoader The parameter must be greater than or equal to 1 taxer The parameter must be greater than or equal to 1 dispatcher The parameter must be greater than or equal to 1