Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Deadlock in DB2 jobs because of jrun.exe contention

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Arun6578

New User


Joined: 23 Jul 2007
Posts: 9
Location: CBE

PostPosted: Fri Jan 11, 2008 11:35 am    Post subject: Deadlock in DB2 jobs because of jrun.exe contention
Reply with quote

Hi,
I have a problem in my mainframe jobs. I am getting deadlock very often because of jrun.exe contention. I was left blank what can be done to prevent this deadlock issue.
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Jan 11, 2008 6:30 pm    Post subject:
Reply with quote

jrun.exe sounds like a PC problem.
Back to top
View user's profile Send private message
Arun6578

New User


Joined: 23 Jul 2007
Posts: 9
Location: CBE

PostPosted: Mon Jan 14, 2008 5:49 pm    Post subject: Reply to: Deadlock in DB2 jobs because of jrun.exe contentio
Reply with quote

I have a store proc which will fetch records from this Database from Java server(Jrun.exe). When my job is trying to update the data in that particular database i am getting deadlock error. I am not sure how to prevent this issue.
Back to top
View user's profile Send private message
Arun6578

New User


Joined: 23 Jul 2007
Posts: 9
Location: CBE

PostPosted: Mon Jan 14, 2008 5:54 pm    Post subject: Reply to: Deadlock in DB2 jobs because of jrun.exe contentio
Reply with quote

Even i have faced a problem like, When my job is updating the database when any online customer logged and access this database again my job will be abended with contention.
) PLAN=DISTSERV WITH 449
CORRELATION-ID=jrun.exe
CONNECTION-ID=SERVER
LUW-ID=GA9E139B.N708.14F413155933=11804
THREAD-INFO=INDAPPP:*:INDAPPP:jrun.exe
IS DEADLOCKED WITH PLAN=INDPBTC0 WITH
CORRELATION-ID=INDSSERU
CONNECTION-ID=BATCH
LUW-ID=NETAUN.ADPRD7.C1CB49D2B63C=39976
THREAD-INFO=INDJOBS:*:*:*
ON MEMBER PRD7
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Fri Feb 22, 2008 8:53 pm    Post subject:
Reply with quote

depending on the functionality performed by the online user...changing isolation level of select can help..
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts How to show message using batch jobs madprasy TSO/ISPF 7 Fri Sep 09, 2016 6:55 pm
No new posts Don't allow CICS to submit batch jobs prino JCL & VSAM 5 Mon Jul 25, 2016 3:26 pm
No new posts Predicting jobs which are about to re... kpanchabhai85 DFSORT/ICETOOL 4 Thu Jun 30, 2016 7:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us