Re: Problems with query tuner java exception

‏2012-12-17T09:10:06Z

This is the accepted answer.
This is the accepted answer.

Sorry for late response. We weren't able to reproduce your problem based on your DDLs. If the problem is still here, would you help get the access plan for further analysis? And an entire trace would be much helpful.
1. Collect the access plan.
1) If you can run Access Plan Graph successfully, it's simple to get the access plan file by using the "save" button on the screenshot (attached)
2) Send the .xml file to liuljun@cn.ibm.com
2. collect the trace file.
1) Open the Data Studio client that you use for query tuning.
2) Open the Query Tuner preferences page by clicking Window > Preferences > Data Management > Query Tuner.
3) Ensure that the trace option is enabled, click Clear Trace to remove previous trace information, and specify a directory for the trace files.
4) Remove all existing Query Tuner trace information by clicking Clear Trace.
5) Specify a directory to store the trace files and then click OK.
6) Re-create the Query Tuner problem to record the Query Tuner trace information.
7) Open the directory which shown in the preference page, sort the files by "Date Modified" to find the latest trace file, then send the file to liuljun@cn.ibm.com (It is better to compress the file in zip format).