Re: Row / Page Locking?

Posted in 2005

Art S. Kagel — Tue, 22 Feb 2005 14:03:12 -0500 — source: Usenet: comp.databases.informix

Marco Greco wrote: Not to mention the venerable: dbschema -d database -t tablename -ss --or <shameless and unneccessary plug> myschema -d database -t tablename -s Art S. Kagel > Hmmmm, after three or four sql based answers, one cannot but wonder whatever > happened to oncheck -pt database:tablename? > > Claus Samuelsen wrote: > >>Geezer From The Freezer wrote: >> >> >>>Whats the best way to find out if a table is being row or page locked? >> >> >>SELECT locklevel FROM systables WHERE tabname = 'tablename';>> >>'R' = row, 'P' = page >> >> >> > > >