IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Controlling usage of resources by tasks


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
raja1128

New User


Joined: 09 Jan 2007
Posts: 17
Location: india

PostPosted: Fri Nov 06, 2015 9:53 am
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Senior Moderator


Joined: 14 Mar 2007
Posts: 10712
Location: italy

PostPosted: Fri Nov 06, 2015 10:24 am
Reply with quote

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
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1565
Location: Andromeda Galaxy

PostPosted: Fri Nov 06, 2015 1:45 pm
Reply with quote

Also did you try to exclusive lock the table?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Fri Nov 06, 2015 8:54 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts DB2 group member usage DB2 0
No new posts Any limit on usage of cursors ? DB2 1
No new posts Usage of processor directive and firs... PL/I & Assembler 4
No new posts usage of CASE in WHERE clause DB2 10
No new posts Usage of pre-processor statement in p... PL/I & Assembler 1
Search our Forums:

Back to Top