Archives of the TeradataForum

Message Posted: Tue, 21 Jul 2009 @ 13:55:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

In contrast to Tpump, Fastload and Multiload utilities lock the entire table.

Statements requesting a write operation on the same table should wait in queue until fastload & multiload finish their jobs. (Multiload can allow writing to the table until application phase. Thereafter, it acquires write lock, making the table unavailable for parallel writes by other requests).

On the other hand, Tpump uses only rowhash locking, thus allowing the other rows of the table be available for write by any other requests. Ultimately, more overall parallel processing.

You can do simultaneous inserts on one common table by running two different tpump jobs.

Regards,

Hemanth.

	<Prev	Next>		<<First	<Prev	Next>	Last>>