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:Figure 1. Subject wsName set Email
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