Results 1 to 5 of 5
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    50

    Unanswered: LOAD Vs IMPORT in HADR

    What are pros and cons of using IMPORT in HADR with ROS?
    Stella
    Last edited by StellaZhang; 08-04-16 at 22:33.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    IMPORT uses logged inserts and updates. Hence if you import on the primary, it should replicate to the standby(s), though you might want to carefully set a COMMITCOUNT for the import if volumes exceed the speed of replay.

    Depending on your DB2 version, consider also INGEST.

    LOAD is unlogged for organize by row tables, but if you are using load-copy and your standby has access to the copies there's also the ability for the standby to process (load) from those load-copies.

  3. #3
    Join Date
    May 2015
    Location
    Korea
    Posts
    50
    Quote Originally Posted by db2mor View Post
    IMPORT uses logged inserts and updates. Hence if you import on the primary, it should replicate to the standby(s), though you might want to carefully set a COMMITCOUNT for the import if volumes exceed the speed of replay.

    Depending on your DB2 version, consider also INGEST.

    LOAD is unlogged for organize by row tables, but if you are using load-copy and your standby has access to the copies there's also the ability for the standby to process (load) from those load-copies.
    Thanks, we are on v97, so INGEST is out.

    What is a recommended or widely used option in such case? LOAD or IMPORT? Why?

  4. #4
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    It depends on your business environment , the concurrency requirements, the availability requirements, the volume to be loaded, and the nature of the workload and the design of the target tables and the SLAs that are in place for RTO/RPO etc.
    'one size does not fit all'.

  5. #5
    Join Date
    Aug 2016
    Posts
    7
    Provided Answers: 1
    Import is better and safe, but has overload on transaction logs

    Load is fast and has no logging but it all depends how well you have configured the load copy options.

    regds
    Paul

Posting Permissions

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