Verifying a tables LOCK MODE
Posted in 1996
DMurray370@aol.com — — source: Informix-list mailing list archive (1991-1998)
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! Thank you Dave