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\ja va\jdk\bin\..
8 java.vendor.url .bug =
9 awt.toolkit = sun.awt.windows .WToolkit
10 file.encoding.p kg = 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.fullversio n = 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\sa mples\java
25 java.class.path =
..:C:\Program Files\SQLLIB\li b;C:\Program Files\SQLLIB\ja va;
C:\Program Files\SQLLIB\ja va\jdk\bin\
26 java.class.vers ion = 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.DB2Dri ver -> DB2Driver() (2004-06-17 12:27:19.437)
| Loaded db2jdbc from java.library.pa th
| DB2Driver: JDBC 2.0, BuildLevel: s030728
jdbc.app.DB2Dri ver <- DB2Driver() [Time Elapsed = 0.0] (2004-06-17
12:27:19.437)
DB2Driver - connect(jdbc:db 2:SAMPLE)
jdbc.app.DB2Con nection -> connect( SAMPLE, info, DB2Driver: JDBC 2.0
s030728, 0, false ) (2004-06-17 12:27:19.452)
| 10: conArg =
| 10: connectionHandl e = 1
jdbc.app.DB2Con nection <- 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
JDBCTRACEPATHNA ME="D:\Working-Directory\"
JDBCTRACEFLUSH= 1