Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Conversion of DLI update Jobs as BMP ... Gopinath Shanmugam IMS DB/DC 3 Wed Dec 20, 2017 12:02 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts self-restarting jobs in OPC jzhardy IBM Tools 1 Mon Aug 21, 2017 10:15 am
No new posts DB2 utilities, contention or failure? sheersh DB2 2 Fri Apr 21, 2017 6:18 pm
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm

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