3.2.16 Operands related to global buffers
- 45) pd_dbbuff_wait_interval = global-buffer-occupation-state-check-interval
- ~<unsigned integer>((0-2147483647))(milliseconds)
- This operand is applicable only to HiRDB/Parallel Server.
- Specifies the interval at which the global buffer occupation state is to be checked. Specifying this operand changes the method of checking the global buffer occupation state.
- When this operand is not specified
- The following processing occurs:
![[Figure]](figure/zu020030.gif)
- When this operand is specified
- The following processing occurs:
![[Figure]](figure/zu020031.gif)
- Specification guidelines
- Specify this operand when all of the conditions listed below are satisfied. Performance might improve. Typically when this operand is used, a value of 1 is specified.
- Global buffer lock-release wait has occurred. (You can check for this based on WAITL in the execution result of the pdbufls command.)
- You want to improve performance, even if doing so increases the CPU usage rate.
- If the CPU usage has become too high because 1 was specified in this operand, increase the value. If there is unused capacity in the CPU usage rate when 1 is specified in this operand, increase the pd_dbbuff_wait_spn_count operand value. Performance might improve.
- 46) pd_dbbuff_wait_spn_count = maximum-spin-loop-count-for-global-buffer-occupation-state-checking
- ~<unsigned integer>((0-2147483646))
- This operand is applicable only to HiRDB/Parallel Server.
- Specifies the maximum spin loop count in an interval loop that can occur during global buffer occupation state checking. For details, see the description of the pd_dbbuff_wait_interval operand.
- Specification guidelines
- Normally, there is no need to specify this operand. Specify this operand when you specify 1 in the pd_dbbuff_wait_interval operand.
- Operand default
- When this operand is omitted, the specification of the same operand in the system common definition is assumed. When the same operand is also omitted in the system common definition, the default is 0.