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%"....
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)