RE: LockLevel question

Posted in 1999

Cardwell Lori B — Tue, 20 Jul 1999 16:54:15 -0500 — source: Informix-list mailing list archive (1991-1998)

Look in systables, and you shall find what you are looking for. Locklevel "R": Row, "P": Page -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Bobby Medus Sent: Tuesday, July 20, 1999 11:02 AM To: informix-list@iiug.org Subject: LockLevel question Hello all, I am trying to find a way to determine a tables locklevel from the Sysmaster database. I see that "sysdic" has a "dic_locklevel" that is set to 1 for page and 2 for row but this is only benifitial if the table is being accessed at the time of query. I know I can get it in the systables in each database but security restrictions forbid me from doing this on certain databases. Any help is appreciated as always. Bobby