Re: dbload and load both very slow

In article <7mma5j$432$1@nnrp1.deja.com>, I, JSalomon@bn.com wrote: > I have just moved a bunch of empty tables into a new dbspace > using "alter fragment". After each move, I loaded them up with a load > command and a unl file. > > One table - with about 1.3 million rows - is giving me trouble. In the > first attempt to load, it got a "long transaction rollback" and about > the halfway mark. No problem, just use the trusty "split" utility and > use 4 load commands. > > After over an hour, when I noticed it was still working on the same > unl file, I peeked into systabinfo for tu_nrows. It was something > like 12. > > I went to get dinner and, upon returning, founr 27 rows loaded. > > This is NUTS! -- SNIP -- Thanks for the valiant efforts of Yuri and some others who responded by e-mail. But sorry, none of your ideas - or even all combined - cound not have accounted for this drag. In a fit of inspired madness, I deleted the table, rebuilt it and the restarted the load. It loaded like a greasy senatorial candidate switching positions! it started at ~1000 rows/second! Of course is slowed down after hte first 400,000 rows. I would have liked to chase down the mystery but hey, I had soem real- world work to get done! +---- Jacob Salomon DBA JSalomon@bn.com --------------------+ |(In perpetual pursuit of undomesticated semi-aquatic avians)| | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+ Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.