Installing the SQL Profiler on the server

Installing the SQL Profiler on IBM RAD

1.      Download RAD-SQL Profiler folder from the sample zip file.

2.      Copy the jdbcProfiler.jar into your D:\IBM\SDP\runtimes\base_v7\lib\ext directory

3.      Start your WebSphere Commerce Toolkit.

4.      In your WebSphere Commerce Toolkit workspace, make sure you are in the J2EE perspective.

6. For BD2 : Go to 'WC/META-INF/ibmconfig/cells/defaultCell/applications/defaultApp/deployments/defaultApp/resource.xml ' and change the implementationclassName of JDBC as below,      

IBM DB2 Type 4 JCC com.ibm.issw.jdbc.wrappers.WrappedDB2JCCDataSource

7. Unzip 'updatesite' and now go to RAD workspace,

go to Help --> Software Updates --> Available Software and click on 'Add Site' and select Local, now point to the updatesite folder which we unzipped. Now install it by selecting all default values. After this RAD will be restarted.

8. Now clean and publish the workspace, and restart the server, verify SQL profiler is working, Open SQL profiler repositories and click on the green play button to connect it, Now we can see all the SQL for the events ( like productDisplay page ) done on the server.

Refrence : SQL Profiler