DevTest DB2 JDBC simulation using Squirrel

Document ID : KB000100250
Last Modified Date : 05/06/2018
Show Technical Document Details
How to record DB2 jdbc transaction using Squirrel ?
All supported DevTest Environments.
Here are the steps to follow: 
1.Downloaded Squirrel as the Client to send the Jdbc queries to DB2 
2. Configure DB2 connection strings in Squirrel,  Downloaded DB2 driver  and include that jar in Squirrel. 
3. Create a folder /Agentfiles  and Copy Agent dependency file to this folder ( LisaAgent2.jar, LisaAgent.jar and InsightAgent.jar from the server)
4. In the Squirrel start up script add the Agent parameter to this line.

filename: squirrel-sql.bat , Add the agent line to this file just above the line that start with
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%"....

set JAVA_TOOL_OPTIONS=-javaagent:C:\LisaAgents\9.1.0\InsightAgent.jar=name=jdbcTestAgent,url=tcp://localhost:2009

5 Start DevTest components,  and Squirrel Console.  

In the Agent Logs you should see that  Agent is Started  and the Broker console shows the  Squirrel Agent started ( with a green flag)