RE: Table locking problem.
The default is page-level locking. Forget about the config file, you can
change the lock mode through a simple sql statement run in dbaccess. This
will change the table to row-level locking and should certainly ease your
problem.
alter table <table name> lock mode (row)
-----Original Message-----
From: Arvind Sharma [SMTP:asharma@uswest.com]
Sent: Thursday, September 09, 1999 11:12 AM
To: informix-list@iiug.org
Subject: Table locking problem.
This is a multi-part message in MIME format.
--------------2D4F658562E7DA36581A3926
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi,
We have Informix 7.3x on HP-UX. The problem is whenever a user is
trying to update a table the user is not able to query also. There are
around 100 users in our system. They get error 244 when they are trying
to query a row. I used to think that informix uses row label locks by
default. But it seems here it is page lable. Are we doing something
wrong. Do we need to set some parameter in the config file so that the
locks are row label. I am getting lot of complaints because of this. Any
help will be greatly appreciated. Please send a copy of your reply to
"asharma@uswest.com".
Thanks
Arvind
--------------2D4F658562E7DA36581A3926
Content-Type: text/x-vcard; charset=us-ascii;
name="asharma.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Arvind Sharma
Content-Disposition: attachment;
filename="asharma.vcf"
begin:vcard
n:Sharma;Arvind
x-mozilla-html:FALSE
org:Tata Consultancy Services
version:2.1
email;internet:asharma@uswest.com
tel;fax:303-624-0500
tel;home:303-399-4762
tel;work:303-624-5052
adr;quoted-printable:;;931, 14th Street, Room #830 (work)=0D=0A900, S.
Quince St., #B511(home);Denver;Co;80231;US
x-mozilla-cpt:;56096
fn:Arvind Sharma
end:vcard
--------------2D4F658562E7DA36581A3926--