Re: long transaction - URGENT

It seems that you try to load more data in one transaction than your logical logs can handle. Here are some hints to solve the problem: - try to increase the amount of logical logs using "onparams -a -d <tablespace> -s <size>" - try to split your data into several files and load them separately - use "dbload" instead of "load from" to avoid long transactions. Set "commit" to a low value so your logical logs can handle the data. Hope this helps, Christian Brauer Andreas Lommel schrieb: > Hi > I have a problem with my database (workgroup 7.23 for WinnT). I tried to > insert some rows (delimiter) into a table. There occurs an long > transaction error and the table is not filled. > What can I do ? > I tried ontape -s -d dbspacename. > I tried shutdoen... always the same problem ! > Thanks for your help