Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

[closed] trace jdbc connection DB2 on z/OS

 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>

0 votes


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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 84
× 69
× 12

Question asked: Jan 08 '18, 10:45 a.m.

Question was seen: 4,018 times

Last updated: Jan 08 '18, 11:15 a.m.

Confirmation Cancel Confirm