When monitoring Oracle, SQL Server or DB2, Ignite has the ability to not monitor specific SQL coming from a particular program, user, host, etc. or a combination of several of those criteria. For example, it could exclude a SQL when run by a particular user or exclude all SQL coming from a user on a particular machine. This is often used to exclude long running SQL such as backups, data loads, etc.

Note: all SQL in this doc is against the repository database. 

Excluding by SQL only

See article http://support.confio.com/kb/1556

Sybase Note:  Ignite only supports exclusion by an Ignite hash value for Sybase.  Other exclusion criteria (below) is not supported.

Excluding by other criteria (or a combination of criteria)

Follow the directions below to exclude by other criteria such as by the executing program, user, host, etc.

1)      Go the main page of Ignite

2)      Click the “Options” link

3)      Click the “Advanced Options” link

4)      Check the “Support Options” checkbox

5)      In the monitored database section, choose the database instance from the drop down list

6)      Scroll down and find the “QUICKPOLL_WHERE_CLAUSE”parameter

7)      Click the “Edit” link next to the parameter

8)      Put in the appropriate phrase based on your database instance type from below. Make sure to restart the Ignite monitor after making the changes.

SQL Server Monitored Instance Syntax: 

Example 1)  excluding all SQL from the TSQL program logging in from the server ‘HPSERVER’

                and not (s.program_name='TSQL' and s.hostname='HPSERVER')

Example 2) excluding a SQL if it comes from a particular user (it’s not excluded if coming from other users). In this case you need to find the sql_handle of the sql. You can exclude by the Ignite sql hash by following the directions in the previous section.

 and not (s.loginame='Bob' and s.sql_handle=0x00987097097897)

Example 3) excluding all SQL being executed in the master database by the dataload program

                and not (db_name(s.dbid)='master' and s.program_name='dataload')

Oracle Monitored Instance Syntax:

Example 1)  excluding all SQL from the SAP.exe program logging in from the server ‘HPSERVER’.

and not ("u".ksusepnm ='SAP.exe' and "u".ksusemnm='HPSERVER')

Example 2) excluding a SQL if it comes from a particular user (it’s not excluded if coming from other users)

and not ("u".ksuudlna='Bob' and "u".ksusesqh =97097897)

DB2 Monitored Instance Syntax:

Example 1)  excluding all SQL from the SAP.exe program logging in from the server ‘HPSERVER’.

and not (ai.appl_name ='SAP.exe' and ai.client_nname='HPSERVER')

Example 2) excluding a dynamic SQL if it comes from a particular user (it’s not excluded if coming from other users)

and not (ai.auth_id='Bob' and s. stmt_text  like '%insert into bad_table%')

Example 3) excluding a static SQL if it comes from a particular user (it’s not excluded if coming from other users)

and not (ai.auth_id='Bob' and st. text  like '%insert into bad_table%')