Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: Large Table Export

    What is the quickest way to dump a large d2 table? I would prefer not to use export, because its to slow. Is there an export equivalent to the load command ?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by redwolf
    What is the quickest way to dump a large d2 table? I would prefer not to use export, because its to slow. Is there an export equivalent to the load command ?

    Thanks
    The only thing I know of that bypasses the db engine to dump data is db2dart, which lets you dump stuff in delimited ASCII, but that's not done for efficiency - it's for emergency recovery when you don't have a backup.

    I think you're stuck with EXPORT... which should be very fast?
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    agree with Petruk, and don't use db2dart(read carefully before using it)

    regards,

    mujeeb

Posting Permissions

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