It's all about the answers!

Ask a question

[closed] trace jdbc connection DB2 on z/OS


Fons Maathuis (25215) | asked Jan 08 '18, 10:45 a.m.
closed Jan 08 '18, 11:15 a.m. by Ralph Schoon (63.1k33646)

 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>

The question has been closed for the following reason: "Duplicate Question" by rschoon Jan 08 '18, 11:15 a.m.