Re: Verifying a tables LOCK MODE

DMurray370@aol.com wrote: :HI: :In order to reduce the number of "dead-locks" on my INFORMIX 7.11 database, :I've attempted to change one of the tables from page to row level locking. :After I did this I ran DBSCHEMA to verify that the change had actually taken. :I wasn't able to locate the ALTER TABLE XXX LOCK MODE (ROW) anywhere in the :schema. I'm not certain that the lock mode for this table was actuallly :changed or not. Shouldn't DBSCHEMA report on a tables LOCK MODE if it isn't :set to the (page) default? If not, how can I check on a tables LOCK MODE?? :I'd appreciate any info you could provide me with! dbschema -d dbname -ssgives lock mode for every table at the end of the create table statements on my machine. There are no alter... statements. This is according to TFM. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company