Re: long transaction job then aborted with the following error number 458
Posted in 2005
Hi Friend, My approach is to split the load. Don't send 350,000 record one go!!!!! Split it!!! Maybe 100,000 records/batch or 50,000 records/batch Any comments, the rest of the friends????? Cheers. @ --- Muthana.AL-Temimi@tu-harburg.hamburg.de wrote: > Dear IIUG > > I have a problem and it seems to me the same that I > have before when I want load a table with 350000 > records but now what I have is a job try to access > three tables and write the result in the forth > table. The job cannot be continued after ten minutes > I got the following long transaction aborted with > the following error number 458. > > How can I manage this problem? Any help will be > helpful and good > > Regards > Muthana AL-Temimi > > ------------------------------------------ > Technische Universit't Hamburg-Harburg > Muthana AL-Temimi > IuK - Referat > Tel.: 040 42878 3294 > Email: muthana.al-temimi@tu-harburg.hamburg.de > > > sending to informix-list > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com sending to informix-list