KBML types
A KBML type is the domain element against which an action can be executed.
The following are the main subject types of interest in defining scopes, actions, and responses in Query Monitor:
- Db2SqlStatement
- For static SQL, Db2SqlStatement corresponds to a particular section, as identified by the
DB2dbms/plan/program/program version/sectionNumber. For dynamic sql, Db2SqlStatement corresponds to
a select/insert/update/delete statement identified by DB2Dbms/unique-sql-text. Both static and
dynamic SQL are considered to be of type “Db2SqlStatement”.
For subject type Db2SqlStatement and event type Db2SqlEvent, the following properties (attributes) are supported:
- systemTimestamp
- Displays the mainframe timestamp value when the first alert was generated and received on Alerts board.
- Syntax
- ${event.systemTimestamp}
- Type
- Long
- Output
- Returns the mainframe timestamp for particular event when it first been generated in milliseconds.
- systemLastUpdatedTimestamp
- Displays the mainframe timestamp value when the alert was last updated (for example,
repetitionCount was changed for this event).
- Syntax
- ${event.systemLastUpdatedTimestamp}
- Type
- Long
- Output
- Returns the mainframe timestamp when the event being last updated in milliseconds.
- DynamicDb2SqlStatement
- A dynamic SQL statement.
- Db2Dbms
- A Db2 Subsystem.
- Db2ObjectUsage
- The statistics for an object (index or table) collected as this object was used by a specific sql statement.
- Device
- The z/OS® image on which this domain element is contained.
The following subject types also appear, but are less relevant to the contexts in question:
- Dbms
- Similar to Db2Dbms only less specific, and with fewer useful properties.
- Domain
- The whole data center.
- DomainElement
- Anything that can have an alert about it: an SQL statement, a table, an index, a z/OS image, a Db2 subsystem.
- SelfElement
- The Query Monitor application itself: the subject of “self” events such as “Configuration Changed Event” etc.
- Software
- Any kind of DomainElement that is not a Device.
- Sql
- Similar to Db2SqlStatement only less specific, and with fewer useful properties.
- SqlStatement
- Similar to Db2SqlStatement only less specific, and with fewer useful properties.