Re: Verifying a tables LOCK MODE

> From rmy.emory.edu!informix-list-owner@kcig2.att.att.com Wed Sep 4 21:17:12 1996 > >Received: by kcgw2.att.com; Wed Sep 4 20:10 CDT 1996 > From: DMurray370@aol.com > To: informix-list@rmy.emory.edu > Subject: Verifying a tables LOCK MODE > Sender: informix-list-owner@rmy.emory.edu > X-Informix-List-To: rajivp@qsun.ho.att.com > X-Informix-List-Id: <list.11244> > Content-Type: text > > 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 > > Hi, To check the LOCK MODE for a table one can query the systables select locklevel from systables where tabname = 'SomeTableName' It should be = 'R' for row level locking 'P' for page level locking. Also, Did you try dbschema with -ss option. -- Rajiv Jhaveri DBA ================================================================= Voice : (908) 949 7987 Pager : 544 7872 or 1-800 225 0256 PIN 310902 Fax : (908) 949 1726 E-mail: rajivp@qsun.ho.att.com =================================================================