Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

RELOAD-DBH-SESSION

This statement reloads DBH modules and loads a DBH correction version during ongoing operation.

Scope of validity

DBH administration

See also

Function

See section “Dynamic reconfiguration of the DBH session”.

The RELOAD-DBH-SESSION statement reloads the DBH modules.
It cannot be specified in the linked-in DBH.

This also enables you to use a new correction version for the DBH without interrupting ongoing operation. Before the statement is issued, an appropriate correction package must have been installed for the DBH using IMON. This new correction version of the DBH modules is now loaded during ongoing operation using RELOAD-DBH-SESSION. As required, the applications can be reloaded successively and they then use the new DBH correction version.

In addition, new values can be set for the DBH options DBH-TASKS, SYSTEM-THREADS, THREADS and USERS. When you enter a value for USERS which is lower than the number of user which currently exist, SESAM/SQL selects the current number of external users for as the value for USERS.

When the statement is entered with the default values (*UNCHANGED), only the DBH modules are reloaded. The values of the DBH options remain as they are.

If the DBH options cannot be changed, the DBH modules are not reloaded, but the DBH session is aborted. The DBH can be started again with the old options by means of an external restart.

RELOAD-DBH-SESSION

DBH-TASKS = *UNCHANGED / *STD / <integer 1..16>

,SYSTEM-THREADS = *UNCHANGED / *STD / *PARAMETERS(...)


*PARAMETERS(...)



|

WRITE-THREADS = *UNCHANGED / *STD / <integer 1..512>

,THREADS = *UNCHANGED / *STD / <integer 1..1024>

,USERS = *UNCHANGED / *STD / <integer 1..32767>

Operands

See the operand descriptions for the relevant DBH options.

When *UNCHANGED is specified, the value of the DBH option remains unchanged. When *STD is specified, the default value of the corresponding DBH option is used.

Further information

All DBH tasks with the exception of the first DBH task are stopped. The remaining DBH task starts the other DBH tasks using an ENTER command. The other DBH tasks are assigned the same job class as the first DBH task.

SESAM/SQL performs an internal comparison, so the value for THREADS is greater than or equal to double the value of the DBH-TASKS option. This can also result in implicit adjustments to the buffer settings.

In the case of RECONFIGURE-DBH-SESSION the DBH’s memory is restructured or recreated. This also causes the counters which the SESMON performance monitor evaluates for statistical purposes to be reset to “0”.