Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Controlling usage of resources by tasks

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
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    Post subject: Controlling usage of resources by tasks
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 Member


Joined: 14 Mar 2007
Posts: 10700
Location: italy

PostPosted: Fri Nov 06, 2015 10:24 am    Post subject: Reply to: Controlling usage of resources by tasks
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: 1568
Location: Andromeda Galaxy

PostPosted: Fri Nov 06, 2015 1:45 pm    Post subject:
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: 2467
Location: NY,USA

PostPosted: Fri Nov 06, 2015 8:54 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Any limit on usage of cursors ? Jeethendra DB2 1 Sun Jul 12, 2020 10:23 am
No new posts Usage of processor directive and firs... Sakthidevi PL/I & Assembler 4 Fri Apr 10, 2020 6:27 pm
No new posts usage of CASE in WHERE clause abdulrafi DB2 10 Wed Mar 18, 2020 4:25 pm
No new posts Usage of pre-processor statement in p... Sakthidevi PL/I & Assembler 1 Thu Nov 28, 2019 4:08 pm
No new posts Usage of external condition Sakthidevi PL/I & Assembler 1 Sat Nov 23, 2019 1:46 pm

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us