RE: ISAM error: deadlock detected

No you haven't. Hello Julian, how's it going:-)) Try setting the lock mode to a definite time and not to just to 'WAIT' ie 'WAIT 30'. I take it you don't get this problem when you run the stats sequentially and not in parallel?? The last SQL is this when there is nobody else on the box?? Have you run an oncheck recently?? Paul Watson # WF Software Ltd # All answers are Tel: +44 1436 674729 # pure fantasy Fax: +44 1436 678693 # www.wfsoftware.com # > Hi, > > I have been running a suite of Informix 4GL Batch programs for over 2 > years now. The have been running fine up until now :-( > > The system administrator swapped the Unix machine for another > better/faster one and said that all the programs/configuration etc... > has been exactly copied. > > Only now the programs that perform an update statistics get > deadlocks. I > can't understand it as LOCK MODE is set to WAIT and Database > Logging is > ON. > > Has anyone had a similar problem or got any ideas. > > It also gets deadlocks on the following SQL > select distinct colname > from systables a, syscolumns b, sysindexes c > where a.tabid = c.tabid > and a.tabid = b.tabid > and c.part1 = b.colno > and tabname = 'Our_TableName'> > > Specs:- > Unix SunOS 5.7 box. > Informix version 7.24 UC7 > > Julian Mummery > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.