6.2.5 Operand related to the facility for output of extended SQL error information

10) pd_uap_exerror_log_use = YES | NO
Specifies whether to use the facility for output of extended SQL error information. For details about this facility, see the HiRDB Version 9 UAP Development Guide.
YES:
The facility for output of extended SQL error information is used. SQL error information is output to a client error log file and the SQL error report file.
NO:
The facility for output of extended SQL error information is not used.
Specification guidelines
If you manage SQL error information centrally, or output the SQL statements and the parameter information resulting from an error, we recommend that you specify YES.
Operand default value
If this operand is omitted, the value specified for the same operand in the system common definition takes effect. If the same operand is also omitted from the system common definition, NO is assumed.
Relationship to client environment definition
The value of this operand can be changed for each client. To change the operand for a client, specify the PDUAPEXERLOGUSE operand in the client environment definition. If both this operand and the PDUAPEXERLOGUSE operand in the client environment definition are specified, the PDUAPEXERLOGUSE operand takes precedence.
For details about the PDUAPEXERLOGUSE operand, see the HiRDB Version 9 UAP Development Guide.
Effects on individual estimation formulas
If the value of the pd_uap_exerror_log_use operand is changed, the following estimation formula is affected:
HiRDB Version 9 Installation and Design Guide:
  • Determining the size of the memory required to use the facility for output of extended SQL error information under Estimating the memory size required for a HiRDB/Parallel Server