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.
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
IS DEADLOCKED WITH PLAN=INDPBTC0 WITH
ON MEMBER PRD7