Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Linux System/udb Load Parameters

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What's the point of using ORDER BY?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •