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

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -