Re: lock mode problem

Posted in 1996

B. Heede — Mon, 25 Nov 1996 15:02:23 GMT — source: Informix-list mailing list archive (1991-1998)

You can "ALTER TABLE xyz SET LOCK MODE TO ROW" to correct these. (page lock mode is the default) peter_jennings@uk.ibm.com wrote: >Configuration : ONLINE 5 & AIX 3.2.5 >We are opening a database with row locking, but according to tbstat -k the >locks on _some_ of the tables are in page mode, with unfortunate results! >It would seem that the table was somehow created with page locking (before >our time) but we can't find anything in the manuals about this. There is no >mention of lock mode in the ddl either. >How can we check any of this, and correct it? >Peter Jennings