Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    10

    Unanswered: Timeout and Deadlock Errors.

    Hi All,

    I have 2 tables- Master and Child. Master table has primary key and Child has foreign key.

    There is one Application A which performs insert/update/delete oin these tables.

    And Application B which uses Views to read from Master , Child and some othere tables.

    Now I am facing sometimes timeout Errors and sometimes Deadlock Errors at Application A level.

    Request you to help in this regards, so that both the Application A and B can perform simultaneusly.
    Last edited by prat31; 03-03-13 at 08:02.

  2. #2
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    you need to work with your db cfg parameter locktimeout :
    DB2 Universal Database

    And to avoid deadlock you can use better isolation level which suits your application requirement :
    Isolation levels :
    IBM DB2 9.7 Information Center for Linux, UNIX, and Windows

    Currently committed semantics improve concurrency :
    IBM DB2 9.7 Information Center for Linux, UNIX, and Windows

Posting Permissions

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