Re: Table locking & distributed db

In article <34E71CD6.3E6FCFF5@nortel.ca>, gbradet <gbradet@nortel.ca> writes >Does anyone have any idea why the following SQL statements > >SET LOCK MODE TO WAIT;>BEGIN; >LOCK TABLE rem_db@rem_svr:t IN EXCLUSIVE MODE; > >do not work as expected? The lock statement returns after a short >wait with SQL error = 289 and ISAM error = 113. > >The statements above work fine if the table t is local (i.e. >the 'LOCK...' statement waits until all locks are released >before returning). > >We're using DS 7.23 on AIX 4.2. > >Any help/hint greatly appreciated. > >Guy Check you ONCONFIG file. There is a parameter DEADLOCK_TIMEOUT which is the timeout for distributed transactions. If this expires it assume the other machine died... -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care