RE: Locking

Posted in 1998

Wang, Tong — Thu, 13 Aug 1998 15:05:09 -0700 — source: Informix-list mailing list archive (1991-1998)

At the start of transaction, use the "set lock mode to wait.." to change the behavior when table locked(default-return the error code 244 and return immediately.). And not lock a table too long in one transaction. Thanks! tong wang (650)432 7862 > ---------- > From: Thomas Ronzon[SMTP:Thomas.Ronzon@quantum.de] > Sent: Wednesday, August 12, 1998 1:15 AM > To: informix-list@iiug.org > Subject: Locking > > Hi > > I have an Informix Database running on SINIX/Reliant Unix. > The problem is the locking. > When a user starts isql no other user can access the database. > > Where can I change it, so that several users can access the db ?? > > Thomas Ronzon > > Thomas.Ronzon@quantum.de >