Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2008 @ 14:18:43 GMT
<-- Anonymously Posted: Wed, 6 Feb 2008 08:08 -->
Are you getting any rows in the error tables? That slows down throughput dramatically.
Do you have lots of NUSIs on these tables?
Have you checked for lock contention (blocking), e.g. using PMON while batch is running?
Have you checked ResUsage for CPU, memory, etc. utilization?
Is the bulk of the MLOAD time being spent in the Acquisition phase or the Apply phase?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|