Re: Need Locking Edification

>From: "Alton B. Coalter" <renegade@internetMCI.com> >Date: Tue, 19 Aug 1997 17:00:19 -0700 >X-Informix-List-Id: <news.41828> > >Cosmo Lee wrote: >> We're having a problem that when we are running deletes from a table, >> users are locked out from completing Selects, and Inserts fail. We >> can't quite figure out why this happens . . . > >Two comments: firstly, "edification" means "praise." I think you >meant to use the word "clarification." Which dictionary are you using? Chambers 20th Century Dictionary (1978 Edition) says: n. edification, instruction: progress in knowledge or goodness. I think Cosmo was requesting enlightenment, by us giving him instruction, so he would progress in knowledge. That's valid use of English. None of the entries under 'edify' can easily be interpreted as 'praise'. >Secondly, tables are created by default with page-mode locking >wherein a complete page is locked rather than an individual row. >If this is the case (use the -ss option of dbschema, for example), >then change it to row locking instead. This is sound advice... The default lock mode is PAGE, and this is seldom what you want unless your table rows are large enough that you only get one row per page (or one row extends over several pages). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.