Results 1 to 2 of 2

Thread: Locktimeout

  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: Locktimeout

    Hi,

    In my database the LOCKTIMEOUT configuration parameter is set to AUTOMATIC.

    $ db2 get db cfg for test1 | grep 'LOCKTIMEOUT'
    Lock timeout (sec) (LOCKTIMEOUT) = AUTOMATIC

    Please let me know the DEFAULT DURATION.
    AUTOMATIC = ? sec

    Regards,
    Santhosh

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    In this situation a lock will be waited for (if one is not available at the time of the request) until either of the following:

    The lock is granted
    A deadlock occurs.

Posting Permissions

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