IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Terminate CICS transactions accessing particular tables

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> CICS
View previous topic :: View next topic  
Author Message
shanuss



Joined: 16 Jul 2008
Posts: 5
Location: Chennai

Posted: Fri Jul 18, 2008 1:12 am    Post subject: Terminate CICS transactions accessing particular tables  

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  
dick scherrer



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

Posted: Fri Jul 18, 2008 1:26 am    Post subject:  

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  
Earl Haigh



Joined: 25 Jul 2006
Posts: 209

Posted: Fri Jul 18, 2008 3:30 am    Post subject:  

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  
shanuss



Joined: 16 Jul 2008
Posts: 5
Location: Chennai

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

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  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> CICS
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM