HPL/onpload unload slow

I am unloading a table to disk using 40 threads(files) using the HPL.The HPL starts unloading like lightning and then grind to an almost complete halt after unloading about 2 million rows of a 32 million row table ? If I tweak the ipload configuration buffer parms I get a faster start but then it still grinds to a halt at about the same place. I am using a dirty read. Any suggestions ? Steve Sent via Deja.com http://www.deja.com/ Before you buy.

One thing that I've noticed is that the disk where the output file resides may get behind a bit. HP Glance shows this in my environment. Of course, I couldn't say that my testing comes to a grinding halt. I'm curious if there are any (practical) tunable parameters for HPL. John Carlson Informix DBA WHSmith USA evetsm@rocketmail.com wrote: > > I am unloading a table to disk using 40 threads(files) using the HPL.The > HPL starts unloading like lightning and then grind to an almost complete > halt after unloading about 2 million rows of a 32 million row table ? If > I tweak the ipload configuration buffer parms I get a faster start but > then it still grinds to a halt at about the same place. I am using a > dirty read. Any suggestions ? > > Steve > > Sent via Deja.com http://www.deja.com/ > Before you buy.