Table locking & distributed db 
Author Message
 Table locking & distributed db

Does anyone have any idea why the following SQL statements

SET LOCK MODE TO WAIT;
BEGIN;

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



Wed, 18 Jun 1902 08:00:00 GMT
 Table locking & distributed db


writes

Quote:
>Does anyone have any idea why the following SQL statements

>SET LOCK MODE TO WAIT;
>BEGIN;

>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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Default Table Lock-mode for DB-LIB, OLE DB Connections

2. Default Table Lock-mode for DB-LIB, OLE DB Connections

3. Select INTO a temp table & table lock

4. Select INTO a temp table & table lock

5. Distributed Queries & SQL Server tables

6. Newbie question: multiple threads & db locking

7. Table is locked, workstation coughs, table stays locked.

8. lock a table in a db?

9. Set Locks configuration to % of extents of largest table in db

10. Master DB locks up its tables!!!

11. Losing a db connection while table is locked


 
Powered by phpBB® Forum Software