Nonstop Database, HiRDB Version 9 Command Reference

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

10.3.10 option statement (specification of optional functions)

The option statement specifies pdrbal's optional functions.

Criteria
Specify the option statement to change the interval at which the utility is to check whether or not pdrbal can be executed in the shared mode.

Rule
  1. You can specify only one option statement.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 
..option [check_itv=executability-checking-interval]
 

(2) Explanation

(a) check_itv=executability-checking-interval

~<unsigned integer> ((10-180000)) <<10>>

In the shared mode (-k share), pdrbal checks whether or not there is any UAP that accesses the target table. If there is no such UAP, pdrbal moves the data. Specify this executability checking interval in milliseconds.

In the exclusive mode (-k exclusive), you cannot specify this option.

Criteria
Normally, the default value is used.
If the pdrbal workload is large and online applications may be affected adversely, specifying a value that is greater than the default value increases the monitoring interval at which pdrbal checks UAP operation, which is to the benefit of the online applications.