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

Posted in 2004

Misdan Adam — Tue, 13 Apr 2004 08:00:58 +0800 — source: Usenet: comp.databases.informix

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 > > > Based on my past experience (4 years ago), you can do this a) break the file to several smaller files and load them one by one b) increase the logical log to a bigger size c) change the engine logging to NO LOG before loading the records. Upon completion, change back to the original state Thanks Misdan sending to informix-list