RE: error 458: Long transaction aborted

2 million rows in one transaction could use a pretty serious amout of logs How big are your logical logs and how many do you have? I am surprised you didn' t run out of locks... Might you right a program to do cursor inserts for this? Will >Hello > >Does anybody know what is wrong with INFORMIX-Universal Server 9.12 for >UNIX. >If I do a query like this > >INSET INTO tab_2(oid_1, oid_2) >SELECT a1.oid_1, a2.oid_2 >FROM tab_1 t1, tab_1 t2 >WHERE t1.oid_1 <> t2.oid_1 AND > t1.incom < 6000;> >I get always an error 458: Long Transaction aborted. > >The tabe tab_1 has only 2048 rows, so it could be a maximum of 2 mil. >rows in tab_2. > >I did the statement, but seperated into smaler peaces and I received >150000 rows in tab_2. > >I already toled my database administrator and he increases the physical >and logical log space, but it didn't help. >Does anybody know what to do? > >Thank you very much. >Peter, University of Munich > ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------