Re: Verifying a tables LOCK MODE

In article <50l95j$s9o@cssun.mathcs.emory.edu>, DMurray370@aol.com writes >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 Don;t have the manual in front of me but try dbschema -d <database> -t <table> -ss -- David Williams