2.3.11 Operands related to SQL runtime warning output facility

65) 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 8 System Operation Guide.
output-condition-for-SQL-runtime-warning-information (% specification): [Figure]<unsigned integer>((0-99)) or <unsigned decimal number>((0-99.999999))<<0>> (%)
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 method
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))<<0 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
66) pd_cwaittime_report_dir = SQL-runtime-warning-information-file-output-destination-directory
[Figure]<pathname>
Specifies an absolute path name as the output destination directory for the SQL runtime warning information file. Two SQL runtime warning information files (pdcwwrn1 and pdcwwrn2) are created under the directory specified here.
If this operand is omitted, no SQL runtime warning information file is output. However, the warning message (KFPA20009-W) is still output.
For a HiRDB/Parallel Server, the SQL runtime warning information files are output to the server machine containing the front-end server to which the UAP that issued the warning target SQL is connected.
Operand rules
  • Specify no more than 255 characters for the path name.
  • The path name is not case sensitive.
67) pd_cwaittime_report_size = SQL-runtime-warning-information-file-maximum-size
[Figure]<unsigned integer>((2048-2147473627))<<100000>>(Bytes)
Specifies the maximum size for the SQL runtime warning information file. The value specified in this operand indicates the size of a single SQL runtime warning information file. Therefore, be careful about the value you specify for this operand because two SQL runtime warning information files are created. For example, if you specify 10,000, two files, each with a maximum size of 10,000 bytes, are created under the directory.
Specification guidelines
Use the following formula as a guideline when determining the value to be specified for this operand.
{1280 + SQL-statement-size (bytes)} [Figure] number-of-pieces-of-warning-information-to-be-stored-in-file
If a comment or SQL optimization is specified for the SQL statement, also include the size of the comment and the specified SQL optimization size (bytes) in the SQL statement size.
Remarks
  • If the volume of data that is output to an SQL runtime warning information file exceeds the value specified by this operand, the output destination is switched to the other file. The two files are used alternately as this process is repeated. During this process, the oldest information is deleted from the switching destination file.
  • If the volume of the SQL runtime warning information that is output at one time exceeds the file size, not all of the SQL runtime warning information is output. Only the information that fits in the file size is output. In this case, the number symbol [#] is added to the end of the SQL runtime warning information.