Can we monitor DB2 functions like INSERT,UPDATE using CICS event publisher
Hi Team, Currently we are using CEP(cics event publisher) to monitor changes to VSAM files and trigger some events to MQ. Now we are planning to migrate from VSAM files to DB2 and not sure if CEP still supports application event monitoring for DB2 tables and functions like INSERT UPDATE DELETE.
Can you help me to understand this please.
@SandeshB
While CICS cannot capture the INSERT, UPDATE, or DELETE actions against rows in a Db2 table, you might use Db2 triggers for the same purpose. See Db2 for z/OS and SQL concepts in the Db2 for z/OS 11.0.0 documentation for more information.
Leigh Compton
IBM Technical Sales
@SandeshB
I'm guessing that you mean "CICS Event Processing" instead of "CEP(cics event publisher)". I checked with Catherine Moxey, who is an expert on CICS Event Processing at IBM, and she said "if you just mean the event support within CICS, the answer sadly is that we can't detect Db2 accesses in a way that would let us capture them as CICS events".
I was going to suggest that you open a request for enhancement (RFE) against CICS TS, but unfortunately Catherine said this probably isn't possible.
Theresa Hamilton
IBM CICS Technical Support