It's all about the answers!

Ask a question

trace jdbc connection DB2 on z/OS

Fons Maathuis (25215) | asked Jan 08 '18, 10:45 a.m.

 We do have big problems using RTC with DB2 on z/OS. It seems like RTC keeps firing request to the database, which use up a lot of CPU. Apparently for each request RACF is consulted, which also leads to a lot of CPU. 

Even when in idle, RTC keeps using to much resources, so we're trying to determine the problems. 
JDBC has a possibility to trace the connection, but how can I use that in my properties on RTC.

jdbc:db2://localhost:50000/sample:traceDirectory=c:\temp;traceFile=jcctrace.log;traceFileAppend=false;traceLevel=-1; should do the trick, but where to put it? <o:p> </o:p>

Accepted answer

permanent link
Jean-Bernard Curmi (14162) | answered Jan 10 '18, 4:13 a.m.

You can do that by editing your files in
installationDirectory/server/conf/jts and



to your propertie

ie replace;password={password};


Fons Maathuis selected this answer as the correct answer

Fons Maathuis commented Jan 10 '18, 5:01 a.m.

 also found a way to see what happens in DB2, had to change the files. Uncomment a few lines, all is documented in the log4j-files.

Your answer

Register or to post your answer.