Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

9.9.3 Operation method

Organization of this subsection
(1) Procedure for changing the deadlock priority value
(2) Operand specification example

(1) Procedure for changing the deadlock priority value

The following describes the procedure for changing the deadlock priority value.

Procedure
  1. Check the deadlock priority value (value of the PDDLKPRIO operand in the client environment definition) of the transaction that might cause deadlock.
  2. Specify Y in the pd_deadlock_priority_use operand.
  3. Specify a deadlock priority value for commands in the pd_command_deadlock_priority operand.
    Hint
    The following are specification guidelines for the pd_command_deadlock_priority operand:
    • To cause an error in the transaction when deadlock occurs, ensure that the operand specification values satisfy the following condition:
      value of pd_command_deadlock_priority < value of PDDLKPRIO
    • To cause an error in the command when deadlock occurs, ensure that the operand specification values satisfy the following condition:
      value of pd_command_deadlock_priority > value of PDDLKPRIO

(2) Operand specification example

An example of specifying operands is provided for the following outcome:

Example of operand specifications:

Specifying the client environment definition for executing UAP1

 
PDDLKPRIO 32
 

Specifying the client environment definition for executing UAP2

 
PDDLKPRIO 96
 

Specifying the system common definition

 
pd_deadlock_priority_use = Y
pd_command_deadlock_priority = 64