5.2.5 Operand related to the facility for output of extended SQL error information
- 14) pd_uap_exerror_log_use = AUTO | YES | NO
- Select AUTO, YES, or NO to specify whether to apply the facility for output of extended SQL error information. For details about this facility, see the HiRDB Version 9 UAP Development Guide.
- AUTO:
- Applies the facility for output of extended SQL error information. SQL error information is output in a client error log file and an SQL error report file.
- The date and time when error information was output to the SQL error report file and the start, end, and execution times of SQL are displayed in seconds.
- YES:
- Applies the facility for output of extended SQL error information. SQL error information is output in a client error log file and an SQL error report file.
- The date and time when error information was output to the SQL error report file, and the start, end, and execution times of SQL are displayed in microseconds.
- NO:
- Does not apply the facility for output of extended SQL error information.
- 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, AUTO 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 single server configuration