RE: Deadlock question

Posted in 2003

Murray Wood (IList) — Tue, 22 Jul 2003 16:09:36 +1200 — source: Usenet: comp.databases.informix

Are the sqls that crash using the correct index to find data from the database? (explain plan). Update stats? Increase the duration of the set lock mode to wait. Neither of those messages necessarily indicate deadlocks. Why do you think there are deadlocks? MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Jason > Sent: Tuesday, 22 July 2003 11:54 a.m. > To: informix-list@iiug.org > Subject: Deadlock question > > > Broad question. > > Are there any settings in the onconfig, that if not properly > set, could > lead to an increase in deadlock issues (showing a LOT of > -243's and -154's) > . > > I just upgraded to 9.30.FC3 and I am seeing an awful lot of > dead locks... > > Just wondering. > > > > -- > Using M2, Opera's revolutionary e-mail client: > http://www.opera.com/m2/ sending to informix-list