After SQL execution, HiRDB determines the SQL execution time. If this amount of time exceeds a preset elapsed time for output of warning information, the following warning information about that SQL is output; this facility is called the SQL runtime warning output facility:
The SQL runtime warning output facility can be used for the following purposes:
The amount of time on the basis of which warning information is to be output is called the elapsed time basis for output of warning information. When SQL execution time exceeds the elapsed time basis for output of warning information, warning information is output. The elapsed time basis for output of warning information is determined as either of the following:
The SQL runtime warning output facility monitors all SQL statements except for CONNECT statements.
When information warning that a PDCWAITTIME timeout may occur is output, you should take the following actions based on the output information:
When the SQL runtime warning output facility is being used, warning information may be output, even when the execution time of SQL code is less than the set time. Warning information (message only) may also be output, even when the SQL runtime warning output facility is not being used. Table 8-7 describes the conditions under which warning information is output by the SQL runtime warning output facility.
Table 8-7 Conditions under which warning information is output by the SQL runtime warning output facility
Condition | Warning information that is output | ||
---|---|---|---|
SQL runtime warning information file | KFPA20009-W message | ||
When the SQL runtime warning output facility is being used | The SQL execution time meets or exceeds the set time. | Yes | Yes |
Server process is terminated forcibly due to a PDCWAITTIME timeout. | Part | Part | |
Server process is terminated forcibly for some other reason. | Part | Part | |
When the SQL runtime warning output facility is not being used | The SQL execution time meets or exceeds the set time. | No | No |
Server process is terminated forcibly due to a PDCWAITTIME timeout. | No | Part | |
Server process is terminated forcibly for some other reason. | No | Part |
Figures 8-14 and 8-15 illustrate the relationship between PDCWAITTIME and the SQL runtime warning output facility.
Figure 8-14 Relationship between PDCWAITTIME and the SQL runtime warning output facility (1 of 2)
Figure 8-15 Relationship between PDCWAITTIME and the SQL runtime warning output facility (2 of 2)