Resultant Email: subject wsName set

The following email illustrates the type of email that might be sent based on the KBML source code above if an event.type SqlCpuProblem occurs.

In this sample email, the subject.wsName is set and as a result the subject.wsName, subject.wsTran, and subject.wsUser information is output as shown in bold:

From: CQM

To: Fred Jones

Cc:

Subject: identifiers and properties for SqlCpuProblem

Subject:

subject.bestName: I81A:DISTSERV:SYSLH200::2::USERID:::::DIST WORK:81.61.87.-96.18.-9.-67.-73.32.32

subject.collectionId: NULLID

subject.db2dbms.ssid: ssid

subject.db2Ssid: ssid

subject.device.bestName: ssid

subject.plan: DISTSERV

subject.programName: PROGRAM1

subject.programVersion: null

subject.sectionNumber: 2

subject.user: USERID

subject.wsName: userid

subject.wsTran: xxxx.yourcompany.xxxx.s

subject.wsUser: userid

==================

Device:

device.address: nn.n.n.nnn

device.bestName: SS01

==============

Event:

event.autoClear: 9 days

event.datetime: Wed MMM DD HH:MM:SS EST YYYY

event.displayName: Sql Cpu Problem

event.domainElement.bestName: I81A:DISTSERV:SYSLH200::2::USERID:::::DIST WORK:81.61.87.-96.18.-9.-67.-73.32.32

event.isAcknowledged: true

event.message: The sql statement I81A:DISTSERV:SYSLH200::2::USERID:::::DIST WORK:81.61.87.-96.18.

-9.-67.-73.32.32 took 2447 milliseconds of CPU.

event.priority: 3

event.type: SqlCpuProblem

================

Other identifiers

currentDatetime: Wed MMM DD HH:MM:SS EST YYYY

trigger: acknowledged

subject.text:

SELECT CASE WHEN CHAR(DECIMAL(1 / 10, 2, 1)) = ' 0.0' THEN 1 WHEN CHAR(D

ECIMAL(1 / 10, 2, 1)) = ' 0,0' THEN 2 ELSE 3 END AS C1

FROM SYSIBM.SYSDUMMY1