UDB PE 8.1 on Win XP.
Per the manual:
DB2 JDBC traces always begin with a header that lists important system
information such as key environment variable settings, the JDK or JRE
level,
the DB2 JDBC driver level, and the DB2 build level. For example:
1 ================================================== ======
2 | Trace beginning on 2002-1-28 7:21:0.19
3 ================================================== ======
4 System Properties:
5 ------------------
6 user.language = en
7 java.home = c:\Program Files\SQLLIB\java\jdk\bin\..
8 java.vendor.url.bug =
9 awt.toolkit = sun.awt.windows.WToolkit
10 file.encoding.pkg = sun.io
11 java.version = 1.1.8
12 file.separator = \
13 line.separator =
14 user.region = US
15 file.encoding = Cp1252
16 java.compiler = ibmjitc
17 java.vendor = IBM® Corporation
18 user.timezone = EST
19 user.name = db2user
20 os.arch = x86
21 java.fullversion = JDK 1.1.8 IBM build n118p-19991124 (JIT ibmjitc
V3.5-IBMJDK1.1-19991124)
22 os.name = Windows® NT
23 java.vendor.url = http://www.ibm.com/
24 user.dir = c:\Program Files\SQLLIB\samples\java
25 java.class.path =
..:C:\Program Files\SQLLIB\lib;C:\Program Files\SQLLIB\java;
C:\Program Files\SQLLIB\java\jdk\bin\
26 java.class.version = 45.3
27 os.version = 5.0
28 path.separator = ;
29 user.home = C:\home\db2user
30 ----------------------------------------
However, the JDBC trace that my application procuces does NOT have the
above header information; it just has the actual trace information.
Following are the first few lines from the trace:
jdbc.app.DB2Driver -> DB2Driver() (2004-06-17 12:27:19.437)
| Loaded db2jdbc from java.library.path
| DB2Driver: JDBC 2.0, BuildLevel: s030728
jdbc.app.DB2Driver <- DB2Driver() [Time Elapsed = 0.0] (2004-06-17
12:27:19.437)
DB2Driver - connect(jdbc:db2:SAMPLE)
jdbc.app.DB2Connection -> connect( SAMPLE, info, DB2Driver: JDBC 2.0
s030728, 0, false ) (2004-06-17 12:27:19.452)
| 10: conArg =
| 10: connectionHandle = 1
jdbc.app.DB2Connection <- connect() [Time Elapsed = 0.235] (2004-06-17
12:27:19.687)
Why is the header info. not getting published? My db2cli.ini has
following info:
jdbctrace=1
JDBCTRACEPATHNAME="D:\Working-Directory\"
JDBCTRACEFLUSH=1