5.2.4 Operands related to SQL runtime warning output facility

13) 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 about the SQL runtime warning output facility, see the HiRDB Version 9 System Operation Guide.
output-condition-for-SQL-runtime-warning-information (% specification): ~<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)
Operand specification methods
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): ~<unsigned decimal number>((0-65534.999999))sec or <unsigned integer>((0-65534))sec,auto (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)
If auto is specified, warning information is output for the SQL even if the PDCWAITTIME operand is omitted or 0 is specified in the operand.
Operand specification m-ethod
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 the percentage and time duration specification.
Operand rule
If 0, 0sec, or 0sec,auto is specified in this operand, no warning information is output. (The SQL runtime warning output facility is not used.)
Operand default value
If this operand is omitted, the value specified for the same operand in the system common definition takes effect. If the same operand is also omitted from the system common definition, 1800sec,auto is assumed.
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 about the PDCWAITTIMEWRNPNT operand, see the HiRDB Version 9 UAP Development Guide.
Relationship to other operands
This operand is related to the following operands:
  • pd_cwaittime_report_dir
  • pd_cwaittime_report_size