Oninit cdi / Archive
Talk to an expert →

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

Posted in 2004

Summary

Basheer Azeemuddin hit LONGTX on IDS 9.30.UC2 (AIX) during a roughly 100,000-row load. Paul Watson suggested locking the table exclusively, splitting the transaction, or adding logs. Another poster asked about logging type and onstat -l, and advised dbload with periodic commits and sensible extent sizes. Andy Kent questioned the locks suggestion. No confirmed outcome.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

Azeemuddin, Basheer — — source: Usenet: comp.databases.informix

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

↪ replying to Azeemuddin, Basheer
Paul Watson — — source: Usenet: comp.databases.informix

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 #

↪ replying to Paul Watson
TBP@Nospam.Nothere.Co.Uk — — source: Usenet: comp.databases.informix

Paul Watson wrote: > 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 > > Well, not really enough information ... 1. What type of logging are you using BUFFERED, UNBUFFERED, NONE? 2. Use dbload, and commit after every "n" records. 3. What does your onstat -l show? 4. Make sure that you have appropriate extent sizes (avoid loads of DDL logging).

↪ replying to Paul Watson
Andy Kent — — source: Usenet: comp.databases.informix

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

Related threads