Re: Table locking problem.

Arvind AFAIK. Informix uses page level locking by default, but for most OLTP type of applications, we change it to use row level locking. The way to do this is: alter table tablename lock mode (row); or specify the lock mode row in your create table statement. HTH Sujit Arvind Sharma <asharma@uswest.com> on 09/09/99 08:12:04 AM Please respond to Arvind Sharma <asharma@uswest.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) 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--