By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,706 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,706 IT Pros & Developers. It's quick & easy.

db2 jdbc trace ....

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.