Configuring custom SQL queries
You should configure sql queries to get a specific information about the query, like ResponseTime and other parameters.
To configure custom SQL queries
- From the PATROL Console work area, right-click an existing DB2 environment (DB2_ENVIRONMENT).
- Select KM Commands > KM Administration > Custom SQL query configuration.
- In the Custom SQL query configuration dialog box, perform the following actions if defining or editing the information:
- To add a new SQL query, enter the name of the SQL query. This name will appear in the console.
- To add a new instance, enter the name of the database instance. For example: DB2
- To add the database name, enter the name of the database. For example: SAMPLE
- SQL query - Enter the SQL query. For example: select TOTAL_LOG_USED from SYSIBMADM.SNAPDB
- Collection time (in min) - Select the time in minutes.
- Click OK to apply the SQL query on the specified databases.
- Click Cancel to close the dialog box.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*