Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Unanswered: Table Locks during SELECT

    Hi,

    I would like to know when the Sybase IQ db is running with insert/update statements, whether the table gets locked when a SELECT query is executed??
    If so, how the same can be resolved.


    Thanks,

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    When a select is done, a shared lock is placed. That means another shared lock / select can be done at the same time ( = two or more selects at the same time). An insert/delete requires an exclusive lock. Once an exclusive lock has been placed, there cannot be placed another exclusive, or a shared lock.
    When a shared lock has been placed, you have to wait for that process to finish before you can place an exclusive lock, for an insert/delete.

    You can use different locking schemes to prevent needless locking/waiting: allpages, datapages, datarows. You can find in depth information about these locking schemes in the online documentation.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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