JCC Trace Analyser

Topic: Code Place

Subtopic: Cross Platform

Java-Swing application that reads a JCC Trace, parses it and extracts the SQL statements from the trace.

We've written this tool to replace the old JCCTraceParser (from IBM, developed under Curt Cotner's team). The old tool didn't work anymore with the new trace formats and we wanted to use it in our development team.

We maintained the structure of the output with the counters for the method calls and extended it with the SQL statements and their counters.

The new tool also generates a workload file with all the extracted SQL statements. This file can be loaded from IBM Data Studio to further analysis.

Comments and feedback can be sent to

Use it as it is (see disclaimer in the tool help).

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.