lock mode

Posted in 2003

Summary

A user on IDS 7.31/AIX asked how to find out a table's lock mode (row vs page). Replies gave three simple methods: query the system catalog with SELECT tabname, locklevel FROM systables WHERE tabname = 'mytable' (R = row, P = page); run dbschema -d database -t table -ss, which shows lock mode plus extent sizes; or check an individual table with oncheck -pt database:table. The question was answered with no further debate.

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

Topics: Versions, Editions & End-of-Life

WU DAVID — Thu, 06 Mar 2003 08:22:23 — source: IIUG Forums & Mailing Lists

hi everyone, How can I tell which lock mode of the database table is? IDS 7.31 AIX 4.3.3

↪ replying to WU DAVID

Simmons, Keith — Thu, 06 Mar 2003 09:49:43 — source: IIUG Forums & Mailing Lists

David Select locklevel from systables where tabname = "your_table" R = Row P = Page ? B = System Table ? null = Version Identifier Keith -> -----Original Message----- -> From: WU DAVID [mailto:tkwwpicc@cta.cq.cn] -> Sent: Thursday, March 06, 2003 8:22 AM -> To: ids@iiug.org -> Subject: lock mode [608] -> -> -> hi everyone, -> How can I tell which lock mode of the database table is? -> -> IDS 7.31 -> AIX 4.3.3 -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

↪ replying to WU DAVID

Laila H. Larsen — Thu, 06 Mar 2003 11:39:34 — source: IIUG Forums & Mailing Lists

Hi David Try dbschema -d (database) -t (tablename) -ss The -ss shows lock mode + extent size M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F Denmark M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 -----Oprindelig meddelelse----- Fra: WU DAVID [mailto:tkwwpicc@cta.cq.cn]=20 Sendt: 6. marts 2003 09:22 Til: ids@iiug.org Emne: lock mode [608]=20 hi everyone, How can I tell which lock mode of the database table is? IDS 7.31 AIX 4.3.3 ------_=_NextPart_001_01C2E3D4.A6B1FE90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35"> <TITLE>SV: lock mode [608] </TITLE> </HEAD> <BODY> Hi David Try dbschema -d (database) -t (tablename) -ss The -ss shows lock mode + extent size M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F Denmark M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 -----Oprindelig meddelelse----- Fra: WU DAVID [<A = HREF=3D"mailto:tkwwpicc@cta.cq.cn">mailto:tkwwpicc@cta.cq.cn</A>] = Sendt: 6. marts 2003 09:22 Til: ids@iiug.org Emne: lock mode [608] hi everyone, How can I tell which lock mode of the database table = is? IDS 7.31 AIX 4.3.3 </BODY> </HTML> ------_=_NextPart_001_01C2E3D4.A6B1FE90-- ------=_NextPartTM-000-5e2067cb-6b4d-4a09-9ab8-1918f6d73ebc--

↪ replying to WU DAVID

Mark D. Stock — Thu, 06 Mar 2003 12:35:47 — source: IIUG Forums & Mailing Lists

WU DAVID wrote: > hi everyone, > How can I tell which lock mode of the database table is? You can use SQL: SELECT tabname, locklevel FROM systables WHERE tabname = "my_table" or: dbschema -d my_database -t my_table -ss Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+

↪ replying to Laila H. Larsen

Greg.Castle@firstdatacorp.com — Thu, 06 Mar 2003 14:07:58 — source: IIUG Forums & Mailing Lists

You can all select the information from systables. The column to look at would be locklevel. (R=Row, P=Page) Thanks, Greg "Laila H. Larsen" To: ids@iiug.org <LHL@DJOEF.DK> cc: Sent by: Subject: SV: lock mode [612] forum.subscriber @iiug.org 03/06/2003 05:39 AM Hi David Try dbschema -d (database) -t (tablename) -ss The -ss shows lock mode + extent size M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F Denmark M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 -----Oprindelig meddelelse----- Fra: WU DAVID [mailto:tkwwpicc@cta.cq.cn]=20 Sendt: 6. marts 2003 09:22 Til: ids@iiug.org Emne: lock mode [608]=20 hi everyone, How can I tell which lock mode of the database table is? IDS 7.31 AIX 4.3.3 ------_=_NextPart_001_01C2E3D4.A6B1FE90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35"> <TITLE>SV: lock mode [608] </TITLE> </HEAD> <BODY> Hi David Try dbschema -d (database) -t (tablename) -ss The -ss shows lock mode + extent size M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F Denmark M.v.h. Laila Holt Larsen lhl@djoef.dk IT-afdelingen DJ=D8F 33 - 959944 -----Oprindelig meddelelse----- Fra: WU DAVID [<A = HREF=3D"mailto:tkwwpicc@cta.cq.cn">mailto:tkwwpicc@cta.cq.cn</A>] = Sendt: 6. marts 2003 09:22 Til: ids@iiug.org Emne: lock mode [608] hi everyone, How can I tell which lock mode of the database table = is? IDS 7.31 AIX 4.3.3 </BODY> </HTML> ------_=_NextPart_001_01C2E3D4.A6B1FE90-- ------=_NextPartTM-000-5e2067cb-6b4d-4a09-9ab8-1918f6d73ebc--

↪ replying to WU DAVID

Charles R. Johnson — Thu, 06 Mar 2003 18:08:14 — source: IIUG Forums & Mailing Lists

If you want to check tables individually, you can also use: oncheck -pt databasename:tablename Chuck Johnson Director of Finance Morris Polich & Purdy LLP Phone: (213) 891-9000 x167 Fax: (213) 488-1178 cjohnson@mpplaw.com >>> "WU DAVID" <tkwwpicc@cta.cq.cn> 03/06/03 12:22AM >>> hi everyone, How can I tell which lock mode of the database table is? IDS 7.31 AIX 4.3.3 *******CONFIDENTIALITY NOTICE******* *****PRIVILEGED AND CONFIDENTIAL INFORMATION***** The information contained in this document is intended solely for use by the persons or entities identified above. This electronically transmitted document contains privileged and confidential information including information which may be protected by the attorney-client and/or work product privileges. If you are not the intended recipient, be aware that any disclosure, copying, distribution or other use of the contents of this transmission is prohibited. If you received this transmission in error, please notify us by telephone (213-891-9100) and permanently delete this message without making a copy.

lock mode

Related threads

Your privacy choices