Add Event Monitors (Add Jobs Wizard)
With the help of the DB2 Event Monitor you are able to capture SQL statements while they are currently running on the database server. Capturing SQL statements with the Event Monitor allows SQL Scanner to identify problematic SQL statements running on the database server.
To add an Event Monitor in the Add Jobs wizard
-
In the DB2 Event Monitor page of the Add Jobs wizard, a list of available Event Monitors appears on the left-hand list box. Select Show all Event Monitors checkbox to display all the Event Monitors, or unselect to display only the Event Monitors owned by the currently selected schema.
-
Select an Event Monitor and click
. If no Event Monitor files or tables are found in the target directory, then you will be prompted to enter the path of the Event Monitor.
-
To scan the Event Monitors using a particular schema, select the Specify schema checkbox and select the schema using the Schema list.