Re: long transaction job then aborted with the following error number 458
Posted in 2005
Topics: Stored Procedures & SPL
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