6.3.4 Operands related to SQL runtime warning output facility

9) pd_cwaittime_wrn_pnt = output-condition-for-SQL-runtime-warning-information (% specification) | output-condition-for-SQL-runtime-warning-information (time specification)
Specify this operand when using the SQL runtime warning output facility. You can specify this operand using one of the following two methods:
  • Specifying a percentage
  • Specifying a time duration
For details on the SQL runtime warning output facility, see the HiRDB Version 8 System Operation Guide.
output-condition-for-SQL-runtime-warning-information (% specification): [Figure]<unsigned integer>((0-99)) or <unsigned decimal number>((0-99.999999)) (%)
Specifies the condition for outputting SQL runtime warning information of the SQL runtime warning output facility as a percentage of the maximum client wait time (value of the PDCWAITTIME operand in the client environment definition). After SQL execution, HiRDB checks the SQL execution time. If this SQL execution time is determined to exceed the time specified by this operand, the following warning information is output. This is called the SQL runtime warning output facility.
  • SQL runtime warning information file
  • Warning message (KFPA20009-W)
Specification guidelines
Specify this operand as a percentage (%) of the value of the PDCWAITTIME operand. For example, if 100 (seconds) is specified for the PDCWAITTIME operand and 90 (%) is specified for the pd_cwaittime_wrn_pnt operand, HiRDB checks the SQL execution time after SQL execution. If the determined SQL execution time is 90 seconds or longer but less than 100 seconds, the warning information is output.
Example

  PDCWAITTIME = 100
  pd_cwaittime_wrn_pnt = 90

output-condition-for-SQL-runtime-warning-information (time specification): [Figure]<unsigned decimal number>((0-65534.999999))sec (seconds)
Specifies the condition for outputting SQL runtime warning information of the SQL runtime warning output facility as a time duration. After SQL execution, HiRDB checks the SQL execution time. If this SQL execution time is determined to exceed the time specified by this operand, the following warning information is output. This is called the SQL runtime warning output facility.
  • SQL runtime warning information file
  • Warning message (KFPA20009-W)
Operand specification method
Specify the time duration (in seconds) to be used as the output trigger. (You can specify up to the sixth decimal.) Add sec to the specified value.
Example

  pd_cwaittime_wrn_pnt = 0.001sec

The following explanation is the same for both percentage and time duration specification.
Operand rule
If 0 or 0sec is specified in this operand, no warning information is output. (The SQL runtime warning output facility is not used.)
Relationship to client environment definition
You can change the value of this operand for each client. To change it for each client, specify the PDCWAITTIMEWRNPNT operand of the client environment definition. For details on the PDCWAITTIMEWRNPNT operand, see the HiRDB Version 8 UAP Development Guide.
Relationship to other operands
This operand is related to the following operands:
  • pd_cwaittime_report_dir
  • pd_cwaittime_report_size