How do I create a mainframe monitoring task?

anjali.bisht · New User Joined: 09 Aug 2007 Posts: 7 Location: India

So, this is just a design idea for my mainframe based project and I need help on how to make this work technically

I am trying to come up with a technical design for a service which monitors a DB2 table for a change (could be an update / insert) and accordingly initiates another service for further processing.

In case there is no update found, the service should sleep for x amount of time and then check the database again.

daveporcelan · Posted: Fri Sep 01, 2017 4:47 pm

You should create a DB2 Trigger.

Triggers are designed to do exactly what you are looking for.

Since triggers were designed correctly, they do not have this 'sleep' function which is a waste of resources.

Triggers detect the update/insert as soon as it happens and perform a task.

Read all about it:
www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/db2z_triggers.html

fixed

PeterHolland · Posted: Fri Sep 01, 2017 5:38 pm

daveporcelan

Your link is not good.

daveporcelan · Posted: Fri Sep 01, 2017 6:17 pm

I am real bad at the link thing.

I searched on DB2 Trigger.

I came up with this maybe it is better.

www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/db2z_triggers.html

Rohit Umarjikar · Posted: Fri Sep 01, 2017 8:27 pm