Hi -

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

Thanks in advance,
Panditt

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).

Just to add to what Marcus said...

The delete phase, if required, is logged.

Thanks Marcus and db2girl