Output of warning information about the time required for SQL execution (SQL runtime warning output facility)

If SQL execution time exceeds either of the limits listed below, warning information about that SQL can be output.

A percentage of the client maximum wait time (value of PDCWAITTIME operand) that has been set
Amount of elapsed time that constitutes trigger for output of a warning to a file

In the following explanations, PDCWAITTIME refers to the client maximum wait time, and a PDCWAITTIME timeout is an exceedance of the client maximum wait time.

Organization of this section: 8.9.1 Overview of the SQL runtime warning output facility; 8.9.2 Using the SQL runtime warning output facility; 8.9.3 Information output to the SQL runtime warning information file; 8.9.4 Output of the KFPA20009-W message; 8.9.5 Notes

8.9 Output of warning information about the time required for SQL execution (SQL runtime warning output facility)