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 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): ~<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, the warning information for the SQL is output even if PDCWAITTIME is omitted or specified as 0.
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.
Operandrule
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.)
Relationshiptoclientenvironmentdefinition
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:
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.
For a HiRDB parallel server configuration, 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 statement is connected.
Operandrules
Specify no more than 255 characters for the path name.
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.
Specificationguidelines
Use the following formula as a guideline when determining the value to be specified for this operand.
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, a hash mark (#) is added to the end of the SQL runtime warning information.