View previous topic :: View next topic
|
Author |
Message |
raja1128
New User
Joined: 09 Jan 2007 Posts: 17 Location: india
|
|
|
|
Hi all,
There are multiple tasks and one db2 table.
At any point of time only one task should access the table.
How this can be achieved?
I read the posts and learnt that it can be done using ENQ, DEQ. Is there any other way in cics?
Pls help.
Thanks. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
put all the transactions that access that table
in a class that is single threaded,
==> allows just one to run and cics will take care of it |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Also did you try to exclusive lock the table? |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Quote: |
I read the posts and learnt that it can be done using ENQ, DEQ. Is there any other way in cics? |
Why,did you not like it or you don't know how to implement?
What if someone modifies the program when you ain't there and then add more files or tables then the Unit of Work is a mess so I advise you to use proper transaction sequencing (ENQ) when you hits millions of trx a day. |
|
Back to top |
|
|
|