Re: locking mode does not show properly

In article <5m7o0p$brr@cssun.mathcs.emory.edu>, ogolde@impsat1.com.ar (Oscar Goldes) wrote: > > Hello, > Im using an Online 7.2 database. I want to find out if the lock mode of > certain tables is page or register. It is row lock mode, not register mode. > If I select from systables... I find they are set as register > However, dbschema does not tell a single word about locking for these > tables, so I have to suppose is is the default, i.e. page. > You have to use dbschema -ss (server specific) option. It tells you all information about database tables like extent sizes, lock modes and so on. Without -ss option you have got only basic info. Oncheck -pt (and oncheck -pT) gives you all info about tables which are read directly from tblspace tblspace. > Which answer is to be trusted? > All, but used in correct form. The highest priority has onchecks` output, because of information in system catalog tables could be changed by not enough experienced user informix. Info in tblspace tblspace is under engine control. > tia, > -- Oscar Goldes > -- Orden Argentina SA I hope this helps. Miroslav Lorenc SSA Czech Republic -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet