Optional alert keys

You can use Optional Alert Keys Configuration to tailor the uniqueness criteria for all Db2SqlStatements. Uniqueness criteria for Db2SqlStatements define what types of SQL are to be grouped together (treated as 'the same') or considered unique (treated as 'different').

To access Optional Alert Keys Configuration, click Configuration > Optional Alert Keys.

You can use Optional Alert Keys Configuration to specify optional alert keys, add fields to the uniqueness criteria for all Db2SqlStatements, group the SQL statements, and send responses or notifications. For example, you can use the optional alert key 'User' to group all of the SQL statements a user executes. You can then create a response (such as sending a notification) so a notification is issued to the user if the queries that user runs exceed a given threshold of CPU consumption. Optional alert keys enable you to allow for more granular processing of generated alerts. For example, in an SAP environment, this enables you to identify SQL as coming from a particular SAP server. If optional alert keys are not used, uniqueness is not generated.

The following optional alert keys are displayed in Optional Alert Keys Configuration:

User: Adds the User field to the uniqueness criteria for all future Db2SqlStatements.
Corrname: Adds the Corrname field to the uniqueness criteria for all future Db2SqlStatements.
WsTran: Adds the WsTran field to the uniqueness criteria for all future Db2SqlStatements.
WsName: Adds the WsName field to the uniqueness criteria for all future Db2SqlStatements.
WsUser: Adds the WsUser field to the uniqueness criteria for all future Db2SqlStatements.
Parallel Threads: Adds the Parallel Threads field to the uniqueness criteria for all future Db2SqlStatements.

The Optional Alert Keys Configuration Editor displays the following additional optional keys for dynamic SQL:

Plan: Adds the Plan field to the uniqueness criteria for all future Db2SqlStatements.
Program: Adds the Program field to the uniqueness criteria for all future Db2SqlStatements.
Section: Adds the Section field to the uniqueness criteria for all future Db2SqlStatements.

Note: The User, WsTran, WsName, WsUser, and Parallel Threads optional alert keys apply to both static and dynamic SQL. The Plan, Program, and Section optional alert keys apply only to dynamic SQL (these optional alert keys are already uniqueness criteria for static SQL).