Re: (LONGTX) V 9.30.UC2 How to get out of this

Posted in 2004

Paul Watson — Tue, 13 Apr 2004 14:48:55 +0100 — source: Usenet: comp.databases.informix

In my experience a locked table will update quicker and as LONGTX is a function of elapsed time, amongst under things, it will help. Andy Kent wrote: > > Eh? What's it got to do with locks? > > Andy > > Paul Watson <paul@oninit.com> wrote in message news:<407B0FAF.309DD022@oninit.com>... > > Lock the table in exclusive mode > > or > > Split the transaction into smaller parts > > or > > Add more logs > > or > > a combination > > > > "Azeemuddin, Basheer" wrote: > > > > > > AIX 4.3.3 V 9.30 UC2 > > > > > > Informix Dynamic Server Version 9.30.UC2 -- On-Line (LONGTX) -- Up 2 > > > days 04:00:45 -- 737696 Kbytes Blocked:LONGTX > > > > > > Started a load job about 100,000 Records. After few minutes got LONGTX. > > > > > > How to get out of this. > > > > > > Thanks > > > Basheer > > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #