IBM DB2 User Manual

For example:
v A TIMESTAMP value of 2009-07-19-10.12.00.000000 is truncated to
2009-07-19-10.12.00.0 after retrieval.
v A TIMESTAMP value of 2009-12-01-11.30.00.100000 is truncated to
2009-12-01-11.30.00.1 after retrieval.
TIMESTAMP_ZERO_PADDING (2)
Trailing zeroes are not truncated in the result of a Resultset.getString
call for a TIMESTAMP value.
traceDirectory
Specifies a directory into which trace information is written. The data type of
this property is String. When traceDirectory is specified, trace information for
multiple connections on the same DataSource is written to multiple files.
When traceDirectory is specified, a connection is traced to a file named
traceFile_origin_n.
n is the nth connection for a DataSource.
origin indicates the origin of the log writer that is in use. Possible values of
origin are:
cpds The log writer for a DB2ConnectionPoolDataSource object.
driver The log writer for a DB2Driver object.
global The log writer for a DB2TraceManager object.
sds The log writer for a DB2SimpleDataSource object.
xads The log writer for a DB2XADataSource object.
If the traceFile property is also specified, the traceDirectory value is not used.
traceFile
Specifies the name of a file into which the IBM Data Server Driver for JDBC
and SQLJ writes trace information. The data type of this property is String.
The traceFile property is an alternative to the logWriter property for directing
the output trace stream to a file.
For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity, the
db2.jcc.override.traceFile configuration property value overrides the traceFile
property value.
Recommendation: Set the db2.jcc.override.traceFile configuration property,
rather than setting the traceFile property for individual connections.
traceFileAppend
Specifies whether to append to or overwrite the file that is specified by the
traceFile property. The data type of this property is boolean. The default is
false, which means that the file that is specified by the traceFile property is
overwritten.
traceLevel
Specifies what to trace. The data type of this property is int.
You can specify one or more of the following traces with the traceLevel
property:
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’)
Chapter 7. JDBC and SQLJ reference information 213
|
|
|
|
|
|
|
|

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