Finding the query execution time


To find out how long it takes a collector or a standard parameter to execute a query, turn Debug on for that parameter. When the parameter completes a polling cycle, look at the Debug output and find the total execution time. Execution times can vary, so to ensure that you find the longest possible execution time, run the Debug on your busiest system during your busiest time.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for DB2 Universal Database 9.0