Re: Row / Page Locking?

Thank you, Art! I thought Brits, unlike Yankees, could read in between lines, but obviously I got my stereotypes wrong! In answer to Keith, my point was that although there are several esoteric ways to obtain some info (eg I can easily get to the lock mode of a partition using only dd and od, or by dumping shared memory), surely the best way to obtain it, in particular for newbies like the original poster, is to use the report specifically written for that purpose? Art S. Kagel wrote: > 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 >>> >>> >>> >> >> >> > -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm sending to informix-list

Marco Greco wrote: > Thank you, Art! > I thought Brits, unlike Yankees, could read in between lines, but obviously I > got my stereotypes wrong! > In answer to Keith, my point was that although there are several esoteric ways > to obtain some info (eg I can easily get to the lock mode of a partition using > only dd and od, or by dumping shared memory), surely the best way to obtain > it, in particular for newbies like the original poster, is to use the report > specifically written for that purpose? Curiously similar to my own point, Marco. Frightening, eh? Art S. Kagel > Art S. Kagel wrote: > > 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 > >>> > >>> > >>> > >> > >> > >> > > > >