Appendix A. Trace Logs

Using Application Trace Logs

The following properties that can be used to specify various kinds of information of SQL statements, error message types, and execution times of SQL statements in the Altibase server in the altibase_boot.log file.

The default value for this property is 0; to specify that information is to be written to a trace log, set the corresponding property to 1.

The value set in the property file can be overridden using the ALTER SYSTEM statement. For more detailed information about this property, please refer to the General Reference > Chapter 2. Altibase Properties.

TRCLOG	Description
TRCLOG_DETAIL_PREDICATE	When EXPLAIN PLAN is set to ON (or ONLY), information about the status of the predicate portion of the WHERE clause is also output.