Skip to Content
author's profile photo Former Member
Former Member

dead locks

hi friends

wat r dead locks and when do they occur and how to check them and modify them

thanq

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 07:48 AM

    hi,

    Deadlocks are situations where two or more applications lock each other, each waiting for the other(s) to release the lock.

    Deadlock situations are detected automatically by DB2 and resolved after a specified time. This time period is determined by database configuration parameter DLCHKTIME.

    The event monitor records the occurrence of deadlocks. To make sure that no data is lost, two event monitors, DB6_EDLMON1 and DB6_EDLMON2, are used. The system switches them on and off alternately, so that one event monitor is always active. The current status of both event monitors is displayed in the Deadlocks group box.

    You can access the Deadlocks screen by calling the DBA Cockpit and choosing Performance -


    >Deadlocks in the navigation frame of the DBA Cockpit. The system displays information from the event monitor that was active before you called this function.

    Regards

    Rahul Bindroo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 07:47 AM

    Hi,

    Deadlocks happen when two or more processes or jobs try to access a particular set of data at the same time. This can be avoided by carefull planning of executing the jobs.

    You can check in the TA DB02, performance and deadlocks. Normally Basis people will deal in deadlocks.

    Regards

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 07:49 AM

    Hi dear,

    look here:

    http://www.webopedia.com/TERM/D/deadlock.html

    Hope it helps!

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.