Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unhappy Unanswered: Lock problem on DB2 Table

    My Centura Appl. uses DB2 Connect to connect to DB2 Database, on one screen I insert in 2 tables, & update on the 3rd. But 3rd table has some problem while updating. My data gets rollbacked properly.
    But If I try to Query the First Table it takes lot of time and at the end I receive Deadlock or TimeOut message.
    Are there any additional settings needs to be one to AVOID TIMEOUT.

    REPLY BACK.
    THANKS IN ADVANCE
    -MILIND

  2. #2
    Join Date
    Nov 2003
    Posts
    12

    Re: Lock problem on DB2 Table

    You should be able to specify the timeout in the connection string. Check your query to find out why does it takes too ling to execute so, check your query first.

    mphilip

  3. #3
    Join Date
    Nov 2003
    Posts
    12

    Re: Lock problem on DB2 Table

    You should be able to specify the timeout in the connection string. Check your query to find out why does it takes too ling to execute so, check your query first.

    mphilip

  4. #4
    Join Date
    Oct 2003
    Posts
    5

    Re: Lock problem on DB2 Table

    Originally posted by mphilip
    You should be able to specify the timeout in the connection string. Check your query to find out why does it takes too ling to execute so, check your query first.

    mphilip
    Thanks for your input, but the Query is simple with a condition.

    Are there any settings to be done for DB2 Connect ?
    -milind

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to find out what is causing the lock contention.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you fixed your rollback problem from this thread:
    http://www.dbforums.com/t969209.html
    please tell us what you did to fix it.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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