set before the driver is loaded and initialized. Changes to
db2.jcc.tracePollingInterval after the driver is loaded and initialized have no
effect.
db2.jcc.t2zosTraceFile
Enables the IBM Data Server Driver for JDBC and SQLJ trace for C/C++ native
driver code for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity,
and specifies the name on which the trace file names are based. This property
is required for collecting trace data for C/C++ native driver code.
Specify a fully qualified z/OS UNIX System Services file name for the
db2.jcct.t2zosTraceFile property value.
For example, specifying the following setting for db2.jcct.t2zosTraceFile enables
tracing of the IBM Data Server Driver for JDBC and SQLJ C/C++ native code
to a file named /SYSTEM/tmp/jdbctraceNative:
db2.jcc.t2zosTraceFile=/SYSTEM/tmp/jdbctraceNative
You should set the trace properties under the direction of IBM Software
Support.
db2.jcc.t2zosTraceBufferSize
Specifies the size, in kilobytes, of a trace buffer in virtual storage that is used
for tracing the processing that is done by the C/C++ native driver code. This
value is also the maximum amount of C/C++ native driver trace information
that can be collected.
Specify an integer between 64 (64 KB) and 4096 (4096 KB). The default is 256
(256 KB).
The JDBC driver determines the trace buffer size as shown in the following
table:
Specified value (n) Trace buffer size (KB)
<64 64
64<=n<128 64
128<=n<256 128
256<=n<512 256
512<=n<1024 512
1024<=n<2048 1024
2048<=n<4096 2048
n>=4096 4096
db2.jcc.t2zosTraceBufferSize is used only if the db2.jcc.t2zosTraceFile property
is set.
Recommendation: To avoid a performance impact, specify a value of 1024 or
less.
For example, to set a trace buffer size of 1024 KB, use this setting:
db2.jcc.t2zosTraceBufferSize=1024
You should set the trace properties under the direction of IBM Software
Support.
db2.jcc.t2zosTraceWrap
Enables or disables wrapping of the SQLJ trace. db2.jcc.t2zosTraceWrap can
have one of the following values:
Chapter 7. JDBC and SQLJ reference information 251
|
|
|
To Next Page
Loading...
Need help?
General