Re: lock mode
Posted in 1995
Munir Noorali — — source: Informix-list mailing list archive (1991-1998)
In article <D9In83.2tw@nntpa.cb.att.com>, ajay@ios.ho.att.com says...
>
>
>What is the default lock mode (page/ row) in informix tables
>(using on-line, if it matters) and also, is there any utility
>(dbschema etc.) one can use to see the current lock mode of a
>table?
>
>--
> ____________________________________________________
> | Ajay Dankar AT&T Bell Laboratories |
> | ajay@ios.ho.att.com Holmdel, NJ 07733 |
> |____________________________________________________|
Default lock mode is page level.
Utility dbschema with option -ss will show the table's lock mode and
extent size.