Archives of the TeradataForum
Message Posted: Mon, 09 Jul 2001 @ 15:25:44 GMT
| Subj: || || Re: Multiload & checkpoint |
| From: || || Fred Pluebell |
Christopher Platt wrote:
| ||Question : Does multiload store incoming transactions in the wt.table until either a checkpoint is forced or it hits the system
default of 15 minutes???|| |
During the Acquire phase, MLOAD stores all "transactions" in the WorkTable. This space is not released until MLOAD completes; CHECKPOINT
is not a factor. WorkTable rows are hashed based on the PI of the target table.
| ||Question2 : I have also recommended that he add his NUSI's after the load and he will get better performance....
Maybe. And if you're running out of WorkTable space during the Apply phase, this is the workaround. In the first part of the Apply
phase, MLOAD applies changes to the table rows and records all corresponding NUSI updates in the WorkTable, to be applied in the second part
of the Apply phase. Again, these NUSI "transactions" remain in the WorkTable until MLOAD completes.