Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Terminate CICS transactions accessing particular tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
Author Message
shanuss

New User


Joined: 16 Jul 2008
Posts: 5
Location: Chennai

PostPosted: Fri Jul 18, 2008 1:12 am    Post subject: Terminate CICS transactions accessing particular tables
Reply with quote

Hi,

I have a job in my applicaton which runs in an hourly basis. It is updating a table which is accessed by CICS users. Due to locking issues, it abends very frequently.

So I want to terminate the CICS transactions which accesses my table, as first step in my job. Are there any JCLs available with you for acomplishing this?

Plase let me know, if my explanatoion is not clear.
Back to top
View user's profile Send private message
References
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 8724
Location: 221 B Baker St

PostPosted: Fri Jul 18, 2008 1:26 am    Post subject:
Reply with quote

Hello,

Before a developer decides to lock out the online every hour, someone in management should be involved. If you have a very busy online system, it may well not be acceptable to lock out some or all of it for a time every hour. . . I suspect that the online system is there to support the users and taking it away every hour is very poor support.

One of the reasons we mostly all use databases is so that concurrent online and batch updates may be processed. If you have developed somethng that will not work properly, it may be time to look into a different approach.
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 219

PostPosted: Fri Jul 18, 2008 3:30 am    Post subject:
Reply with quote

shanuss,

discuss with your management about acquiring some vendor software
that allows you to communicate directly with CICS from a batch
COBOL program.

the following link might help..
http://cicswiki.org/cicswiki1/index.php?title=Category:Batch_Access
Back to top
View user's profile Send private message
shanuss

New User


Joined: 16 Jul 2008
Posts: 5
Location: Chennai

PostPosted: Fri Jul 18, 2008 1:59 pm    Post subject: Reply to: Terminate CICS transactions accessing particular t
Reply with quote

Thank you for your replies. We have got a system support newly and we are trying dig out the issues and corerct them. Thanks for your valuable inputs.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1