concurrency - z/os cics db2 cobol program to process database entries concurrently -


i have db2 table containing large amount of records send out external system via mqs. there column in table containing whether record status (sent or pending sent).

i write scheduler program continually check if there records in table "pending sent". if yes, program send pending records out , update status accordingly

that schedule started in multiple transactions. therefore expecting multiple instances of same program running concurrently

my questions how prevent same records being pick , sent multiple schedulers @ same time?

i told use cursor row level locks? not sure how works

remarks: working on cics cobol in z/os environment

i think have design problem. accomplish similar trying having trigger on db2 table sends mq message queue defined trigger cics transaction.

in case, can dispense cics altogether , @billwoodger suggests , send message when set pending flag.


Comments

Popular posts from this blog

Java 8 + Maven Javadoc plugin: Error fetching URL -

android - How to delete or change the searchview icon inside the SearchView actionBar? -

c++ - Msgpack packing bools bug -