Trigger a CICS Program via DB2 trigger

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

Dear All,

I have a requirement to execute a CICS program whenever an inserts happen in a DB2 table. Can you provide some insights as to whether its possible or not ? If possible, what steps needs to be done ? For example, we have to define the DB2 trigger , then define the CICS PCT,PPT entries.

Eagerly waiting for replies
Thanks !
Thunder~storm

dick scherrer · Posted: Fri Jul 29, 2011 6:19 am

Hello,

Why does someone believe this is a "requirement" . . .

A more proper approach would be to make the needed code external to cics.

This sounds more like someone trying to be clever than actually address a business requirement.

What business function will this code provide/support?

Garry Carroll · Posted: Fri Jul 29, 2011 12:15 pm

Would this DB2 insert be a CICS "event" ??

Garry

enrico-sorichetti · Posted: Fri Jul 29, 2011 7:11 pm

why not look Yourself at the db2 manuals to find out what are the events that can be scheduled by triggers
for db2 9.1 here is the link to the mother of knowledge for DB2
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DSNSHKA3

to save You some searching time here is the direct link to the relevant manual
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPK13/CCONTENTS?SHELF=DSNSHKA3&DN=SC18-9841-03&DT=20081114012927

or to save You more searching time here is the link for just the basics of triggers
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnapk13/2.3.8?SHELF=DSNSHKA3.bks&DT=20081114012927

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

Gary - That's correct. I am expecting the CICS txn to get trigerred with every insert within the table. Obviously , The number of inserts into the table will be very rare. But we want to get notified immediately whenever any insert happens.

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

The trigger documents do not show that any program can be trigerred or any JCL can be run..So, Is it true that we can do only DB2 activities like insert or delete within the trigger ?

enrico-sorichetti · Posted: Sat Jul 30, 2011 5:20 pm

yep!
but since You can also call a stored procedure,
the answer is delayed by one jump

what can You do inside a stored procedure ???

but Your wise db2 support group shoud be aware of
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnapk13/2.7.9?ACTION=MATCHES&REQUEST=dsnacics&TYPE=FUZZY&SHELF=DSNSHKA3.bks&DT=20081114012927&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

the only puzzling comment is