Check the lock mode of a table.

Posted in 2008

Summary

Plamen Kinev asked how to see the lock mode of a table or all tables. Michael Mason and Jack Parker pointed to the locklevel column in systables ('R' is row, 'P' is page). Art Kagel added that dbschema with -ss, or his myschema utility, prints the LOCK MODE clauses. Plamen confirmed it helped.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

PLAMEN KINEV — Mon, 08 Dec 2008 12:29:22 — source: IIUG Forums & Mailing Lists

Hi, guys! I'm interested is there any tool/SQL stament that can tell me what is the lock mode of a given table or the lock mode of all the tables in a certain database? Thanks in advance.

↪ replying to PLAMEN KINEV

Michael Mason — Mon, 08 Dec 2008 12:34:49 — source: IIUG Forums & Mailing Lists

I generally use systables select tabname,locklevel from systables 'R' is row and 'P' is page. But there maybe a tool that shows it as well. Later -Michael A. Mason On Mon, Dec 8, 2008 at 7:29 AM, PLAMEN KINEV <plamenkinev@gmail.com> wrote: > Hi, guys! > I'm interested is there any tool/SQL stament that can tell me what is the > lock > mode of a given table or the lock mode of all the tables in a certain > database? > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- ******************************************** Michael A. Mason www.masonfamilyonline.com ********************************************

↪ replying to PLAMEN KINEV

Jack Parker — Mon, 08 Dec 2008 13:26:49 — source: IIUG Forums & Mailing Lists

locklevel in systables. select tabname, locklevel from systables where tabname='your_table'; cheers j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of PLAMEN KINEV Sent: Monday, December 08, 2008 7:29 AM To: ids@iiug.org Subject: Check the lock mode of a table. [14242] Hi, guys! I'm interested is there any tool/SQL stament that can tell me what is the lock mode of a given table or the lock mode of all the tables in a certain database? Thanks in advance. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jack Parker

PLAMEN KINEV — Mon, 08 Dec 2008 13:30:06 — source: IIUG Forums & Mailing Lists

Thanks a lot. Really helped me. Cheers!

↪ replying to PLAMEN KINEV

Art Kagel — Mon, 08 Dec 2008 16:23:14 — source: IIUG Forums & Mailing Lists

Besides checking the systables entries yourself you can use dbschema ... -ss (or my dbschema replacement utility myschema). Adding the -ss option to dbschema (not needed in myschema) will print out the LOCK MODE clauses for each table listed. Art On Mon, Dec 8, 2008 at 8:30 AM, PLAMEN KINEV <plamenkinev@gmail.com> wrote: > Thanks a lot. Really helped me. > > Cheers! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.