Re: Viewing existing lock mode

Posted in 1996

Lester Knutsen — 24 Jul 1996 23:48:27 -0400 — source: Informix-list mailing list archive (1991-1998)

> > We are trying to find out if a table in the database has row, table or > page locking. We are running with on-line version 5.02. Is there > anyway we can look this up on the current database? Thanks for your > help in advance. > Wendy, You can use the following SQL query: select tabname, locklevel from systables; Locklevel will show B or P for Page level, and R for Row level locking. It works in version 5.X and 7.X. The suggestion to use dbschema with the "-ss" option will only work with 7.X Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################