1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Faster LOAD

    From =?UTF-8?Q?Gregor_Kova=C4=8D?=@21:1/5 to All on Wed Sep 27 02:14:26 2017
    Hi!

    I'm using EXPORT/LOAD to transfer a data for a table from one machine to another.
    Table has almost 20 million rows, exported is 6 GB in size. Using LOAD takes about 3.5 hours. Is there a faster way to transfer a copy of a table from one machine to another one? At the end the target table must be identical to the source.

    Best regards,
    Gregor

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From jbaron@calculo-sa.es@21:1/5 to All on Wed Sep 27 23:36:51 2017
    El miércoles, 27 de septiembre de 2017, 11:14:29 (UTC+2), Gregor Kovač escribió:
    Hi!

    I'm using EXPORT/LOAD to transfer a data for a table from one machine to another.
    Table has almost 20 million rows, exported is 6 GB in size. Using LOAD takes about 3.5 hours. Is there a faster way to transfer a copy of a table from one machine to another one? At the end the target table must be identical to the source.

    Best regards,
    Gregor

    Have you considered to try Data Ingest? It first appeared on version 10.1
    I'm enclosing two articles about it.

    https://www.ibm.com/developerworks/data/library/techarticle/dm-1304ingestcmd/index.html

    http://www.db2dean.com/Previous/DB2INGEST.html

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?Q?Gregor_Kova=C4=8D?=@21:1/5 to All on Thu Sep 28 04:30:38 2017
    I've been testing INGEST today, but it is not faster.
    It is a fascinating concept, but it is not faster than LOAD.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From jbaron@calculo-sa.es@21:1/5 to All on Fri Sep 29 00:17:38 2017
    El jueves, 28 de septiembre de 2017, 13:30:41 (UTC+2), Gregor Kovač escribió:
    I've been testing INGEST today, but it is not faster.
    It is a fascinating concept, but it is not faster than LOAD.

    Good to know. According to the docs it said it was amazingly fast. Perhaps it was not so fast after all.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?Q?Gregor_Kova=C4=8D?=@21:1/5 to All on Fri Sep 29 06:13:50 2017
    Docs on developerWorks states that INGEST is fast, but LOAD is very fast. You can find this in section "Comparing ingest to other methods".

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luiz da Silva@21:1/5 to All on Mon Oct 9 06:44:35 2017
    On Friday, September 29, 2017 at 3:13:52 PM UTC+2, Gregor Kovač wrote:
    Docs on developerWorks states that INGEST is fast, but LOAD is very fast. You can find this in section "Comparing ingest to other methods".

    At your destination database, you can try to load from a remote (cataloged) database without having the intermediate steps of exporting to flat, moving to destination and then loading.

    Example:

    declare C1 cursor database <SOURCE_DATABASE> user <USERNAME> using <PASSWORD> for select * from <SOURCE_SCHEMA>.<TARGET_TABNAME> ;

    load from C1 of cursor replace into <TARGET_SCHEMA>.<TARGET_TABNAME> nonrecoverable ;

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)