Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: Sybase And Websphere

    I face a critical problem:

    I found that the process always blocking other process
    and the locking table is in "sh_intent_demand_blk"
    and in chained mode.

    But i would like to know will it block other process however the process is just a select statment

    Please Help

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Sybase And Websphere

    shared locks are held when pages are being read and its is compitible with other locks

    while there are many process running on db it is usual that few prosses
    are blocked and thereafter released, if any process is blocked for very long time then there something to do with, checkout the process sql and tune that , identify long running transactions and make them short

    for more information abt locking check this out

    http://www.wideopenwest.com/~rsizer/...es/locking.htm

  3. #3
    Join Date
    Feb 2004
    Posts
    28

    Re: Sybase And Websphere

    If I am not mistaken, by default in WebSphere, transaction chained mode is ON for Sybase connections. It means, an implicit begin tran is issued before your run your SQL statements, including SELECTs.

    You should disable chained mode in your JDBC code.

    J

    Originally posted by alfredfong
    I face a critical problem:

    I found that the process always blocking other process
    and the locking table is in "sh_intent_demand_blk"
    and in chained mode.

    But i would like to know will it block other process however the process is just a select statment

    Please Help

  4. #4
    Join Date
    Dec 2003
    Posts
    32
    Then you mean the select also will do locking while other process cant access it.

    Please let me know how to disable the chained mode in JDBC and is there any impact on doing that

    Thx!!

Posting Permissions

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