How do you enable a JDBC trace for a Java Stored Procedure or Java UDF?

http://www-01.ibm.com/support/docview.wss?uid=swg21884054&myns=swgimgmt&mynp=OCSSEPGG&mync=E&cm_sp=swgimgmt-_-OCSSEPGG-_-E

How do you enable a JDBC trace for a Java Stored Procedure or Java UDF?

Question

How do you enable a JDBC trace for a Java Stored Procedure or Java UDF?
Answer

Issue the following command on the database server:

db2set DB2_JVM_STARTARGS=”-Ddb2.jcc.override.traceLevel=-1 -Ddb2.jcc.override.traceFile=/tmp/jdbc_trace -Ddb2.jcc.override.traceFileAppend=true”

… where /tmp/jdbc_trace can be any path/file name that has write privilege by the DB2 fenced user id.

If the database manager configuration parameter KEEPFENCED is set to YES, then this command will require the DB2 instance to be recycled:

db2stop
db2start

To remove this parameter issue the command:

db2set DB2_JVM_STARTARGS=

… and then restart the DB2 instance again (assuming KEEPFENCED=YES is used).

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s