DB2 V8.1 FP9, on Suse linux on AMD
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.
TO change any system parameters, DB CFG , DBM CFG