It's all about the answers!

Ask a question

trace jdbc connection DB2 on z/OS

Fons Maathuis (25417) | 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.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.