Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Question Unanswered: Deadlock prevention

    Hai All,

    We have received morethan 100 deadlocks in sybase(ASE) database. Application is being working in production environment so that I have to fix the this defect in sybase la. what are the steps to be needed to prevent these deadlocks from the application? We made one change that replaced the data tables with page or row data lock from all pages data lock(it includes index pages also), eventhough deadlocks have been generated again after implementation la. Pls request u all people to provide suitable suggestions such way that to fix this defect la.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    if you are going to serialize transactions, that is repeatedly updating the same records then changing locking scheme isn't going to help.

    You first have to understand what that transaction does and then look into changing the lock scheme.

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    if you are going to serialize transactions, that is repeatedly updating the same records then changing locking scheme isn't going to help.

    You first have to understand what that transaction does and then look into changing the lock scheme.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •