Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Load command and logging

    Hi -

    Does load command create logs? If so in which phase ? if not why does it not log?

    Thanks in advance,
    Panditt

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    DB2 LOAD utility does some minimal logging of certain events that happen during the LOAD, but it does not do logging of each transaction. If you want transaction logging, use the IMPORT command (but use a COMMITCOUNT parm to do commits at least every few thousand rows). The reason LOAD does not do logging of each transaction is so it will run faster than an IMPORT (which does inserts). Also, the LOAD command will not fire triggers and skips RI checking because it bypasses the normal insert logic of DB2 in order to get its speed.

    However, if you specify COPY YES on the load, DB2 will include the load file in a place that it can use for roll-forward recovery. COPY YES is slower than COPY NO, but faster than IMPORT (but I don't have any firm numbers on how much slower/faster).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Just to add to what Marcus said...

    The delete phase, if required, is logged.

  4. #4
    Join Date
    Aug 2008
    Posts
    76
    Thanks Marcus and db2girl

Posting Permissions

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