IBM DB2 User Manual

public abstract boolean getTraceFileAppend()
throws java.sql.SQLException
Returns true if the global trace records are appended to the trace file.
Otherwise, getTraceFileAppend returns false.
Related reference
“Properties for the IBM Data Server Driver for JDBC and SQLJ” on page 201
DB2TraceManagerMXBean interface
The com.ibm.db2.jcc.mx.DB2TraceManagerMXBean interface is the means by which
an application makes DB2TraceManager available as an MXBean for the remote trace
controller.
DB2TraceManagerMXBean methods
setTraceFile
Format:
public void setTraceFile(String traceFile,
boolean fileAppend, int traceLevel)
throws java.sql.SQLException
Specifies the name of the file into which the remote trace manager writes trace
information, and the type of information that is to be traced.
Parameter descriptions:
traceFileName
Specifies the file into which global trace information is written. This setting
overrides the settings of the traceFile and logWriter properties for a
DataSource or DriverManager connection.
When the form of setLogWriter with the traceFileName parameter is used,
only one log file is written.
traceFileName can include a directory path.
fileAppend
Specifies whether to append to or overwrite the file that is specified by the
traceFile parameter. true means that the existing file is not overwritten.
traceLevel
Specifies what to trace.
You can specify one or more of the following traces with the traceLevel
parameter:
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_NONE (X’00’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_CONNECTION_CALLS (X’01’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_STATEMENT_CALLS (X’02’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_RESULT_SET_CALLS (X’04’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_DRIVER_CONFIGURATION
(X’10’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_CONNECTS (X’20’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_DRDA_FLOWS (X’40’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_RESULT_SET_META_DATA
(X’80’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_PARAMETER_META_DATA
(X’100’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_DIAGNOSTICS (X’200’)
v com.ibm.db2.jcc.DB2BaseDataSource.TRACE_SQLJ (X’400’)
Chapter 7. JDBC and SQLJ reference information 363
|
|
|
|
|
|

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability