Re: Verifying a tables LOCK MODE

Posted in 1996

Con Woodall — 9 Sep 1996 11:18:09 -0400 — source: Informix-list mailing list archive (1991-1998)

On Wed, 4 Sep 1996 DMurray370@aol.com wrote: --------------- STUFF LEFT OUT --------------- > 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?? --------------- STUFF LEFT OUT --------------- dbschema -d <dbname. -t <tablename> -ss should include table status "in ....... extent size ....... next size ...... lock mode .... Hope this helps -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523, USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu "Ask me about my vow of silence!" --