RE: Table locking problem.
Minor tweak
ALTER TABLE tabname LOCK MODE (ROW);
Without the parentheses, you will have problems.
> -----Original Message-----
> From: Yuri Dovgart [SMTP:y_dovgart@tci.ukrtel.net]
> Sent: Thursday, September 09, 1999 12:55 PM
> To: informix-list@iiug.org
> Subject: Re: Table locking problem.
>
> In article <37D7CE43.9B5866B9@uswest.com>,
> Arvind Sharma <asharma@uswest.com> wrote:
> > 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.
>
> ALTER TABLE tabname LOCK MODE ROW>
> You don't need any changes in your configuration files.
>
>
> --
> With best regards, Yuri Dovgart,
> SAP R/3, Informix consultant,
> "Telecominvest" company.
> E-mail y_dovgart@tci.ukrtel.net
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.