3.2.8 Operands related to SQL runtime warning output facility

10) pd_cwaittime_report_dir = SQL-runtime-warning-information-file-output-destination-directory
~<path name>
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 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.
Operand rules
  • Specify no more than 255 characters for the path name.
Operand default
When this operand is omitted, the specification of the same operand in the system common definition is assumed. If the same operand is also omitted in the system common definition, $PDDIR/spool/pdcwwrn is assumed.
11) pd_cwaittime_report_size = SQL-runtime-warning-information-file-maximum-size
~<unsigned integer>((2048-2147473627)) (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.
(1,280 + 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.
Operand default
When this operand is omitted, the specification of the same operand in the system common definition is assumed. If the same operand is also omitted in the system common definition, the default is 10000000.
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 alternately used 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 hash mark (#) is added to the end of the SQL runtime warning information.