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

CICS transaction ends with Deadlock


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

New User


Joined: 21 Oct 2005
Posts: 22

PostPosted: Mon Mar 12, 2012 7:19 pm
Reply with quote

HI All,

One of our CICS transcaction has failed with dead lock, On analysis we could see that one of the batch program which run every 5 mins is causing the transcation to end in Deadlock

Both the transcaction and batch is using the same db2table to update.

Code:
THREAD-INFO=XXXX:*:*:*
IS DEADLOCKED WITH PLAN=PPPPPXXX WITH
CORRELATION-ID=PPPPPPPP
CONNECTION-ID=BATCH
Please suggest how we can avoid this deadlock.

Thanks
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon Mar 12, 2012 7:30 pm
Reply with quote

how about explaining what the batch job does.

and explain what the transaction does.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Sun Mar 18, 2012 8:49 am
Reply with quote

Hello,

Is this resolved?

The problem is a design issue. One of the processes locks resource A and then tries to lock resource B. At the same time, another process locks resource B and then tries to lock resource A. It may not be trivial to change/correct, but the transactions should lock resources in the same order.
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 CICS / JAVA - Setup of definitions CICS 0
No new posts non-system user tasks in CICS CICS 1
No new posts CICS webservice - Flexible Interface CICS 0
No new posts Prod parallel execution on mainframe ... CICS 1
No new posts COOLGEN - DB2. -927 error while initi... DB2 8
Search our Forums:

Back to Top