Collect SQL statements in WebSphere

To collect SQL statements in WebSphere, configure the ARM engine.

You need to have WebSphere and the data collection infrastructure installed.

1. Shut down WebSphere and the data collection infrastructure.

2. Open the file X:\rpa_install_directory/rpa_prod/tivoli_comp/app/instrument/61/appServers/servername/config/monitoringApplication.properties, where X:\rpa_install_directory is the installation directory and servername is the server running WebSphere.

3. Add the following two lines to the file monitoringApplication.properties:

   1. tmtp.isPrivacyEnabled=false
      

   2. tmtp.isSecurityEnabled=false
      

4. Start the data collection infrastructure.

5. Start WebSphere

What to do next

You will see SQL statements when you collect data.