Team,

DB2 V8.1 FP9, on Suse linux on AMD
uname -a
Linux xxxx 2.4.21-231-smp #1 SMP Mon Jun 28 14:13:46 UTC 2004 x86_64 unknown

TABLE is LINE_ITEM --> Table size is 93GB with 110million rows.

1) Tried load from cursor with order by clause target to LINE_ITEM_NEW
CANCELLED this load after 5 hours. Loaded only 5millioin rows.
2) Tried to export to flat file with "select * from LINE_ITEM order by col1, col2"
CANCELLED this export after 3.5 hours.. Exported only 5.5 million rows.

Please help..

TO change any system parameters, DB CFG , DBM CFG
Thanks
R

What's the point of using ORDER BY?