Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    16

    Unanswered: copy table performance

    I am trying to copy tables from remote database to local database using the "Copy" funtion (Export and Import utilities) from the Control Center. Looks like the performance is not good when the table is very big. Any idea of how to improve the performance of copying tables? Or is there any other better solution to copying tables? Thanks for your help in advance!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: copy table performance

    I'll prefer to do the stuff manually .. Use EXPORT and IMPORT commands ..

    For tuning the IMPORT command have a look at other posts which talk about INSERT Performance and also Performance Tuning Redbook ...

    Cheers

    Sathyaram

    Originally posted by dbques
    I am trying to copy tables from remote database to local database using the "Copy" funtion (Export and Import utilities) from the Control Center. Looks like the performance is not good when the table is very big. Any idea of how to improve the performance of copying tables? Or is there any other better solution to copying tables? Thanks for your help in advance!

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605

    Re: copy table performance

    Hi,

    Try using load instread of import. Load does not use the logs so it is 1000 times faster.

    You can also use db2look command to create scripts for loading data.

    Hope this helps,
    Grofaty

Posting Permissions

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