Custom SQL query configuration dialog box

Warning

This feature is no longer supported by the KM version 9.6.20 and later. For more information see, Release-notes-and-notices.


Use SQL query configuration dialog box to  to get specific information about the query.

Fields

Description

SQL query details

SQL name

Enter the name of the SQL query. This name will appear in the console.

Instance name

Enter the name of the database instance. For example: DB2

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.

OK

Click to apply the SQL query.

Cancel

Click to close the dialog box.


 

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