SQLHELPER_MAX_REDO (Parameter)

Parameter: SQLHELPER_MAX_REDO

Definition

The maximum number of redo attempts when a deadlock occurs on the Core Database

Description and Use

This system parameter specifies the maximum number of redo attempts when a deadlock occurs in the Core Database cache system. The redo attempts are automatically performed by the instance when they are compatible with the specified timeouts (if they exist).

The user is informed when the last attempt failed through a com.highdeal.hci.ServerFailureException.

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

Technical Details

For more information, consult this section.

Name

SQLHELPER_MAX_REDO

The maximum number of redo attempts when a deadlock occurs on the Core Database

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

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