Archives of the TeradataForum

Message Posted: Fri, 07 Jul 2006 @ 16:22:00 GMT


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

Subj:		Re: 104 TERADATA TABLES IN A SINGLE MLOAD

From:		Dieter Noeth

David Holder wrote:

What version of TD are you using to get 15 mloads? I can only run 5 simultaneously in the background on one box. Any others submitted during that time on that box wait for one of them to finish before it will start.

I haven't tried submit more than 5 using more than one box. Is the limit 15 for the DB?

2633 Too many load/unload tasks running: try again later

This error reads that the limit is 5. But is also reads to Check var/adm/streams for more information but I did not see anything there.

Before V2R6.1 the maximum number of concurrent FExp/MLoad/FastLoad-Jobs is 15. It's set using dbscontrol, General Field 11 MaxLoadTasks.

Since 6.1 it might be more than that, following is copied from dbccontrol help:

DBS Control Record - General Fields:

11. MaxLoadTasks - Maximum combined number of FastLoad, MultiLoad, and possibly FastExport. This field works differently depending on the value of MaxLoadAWT.

a) If the internal field MaxLoadAWT is zero (by default), this field is the concurrent job limit for all three utilities: FastLoad, MultiLoad, and FastExport.

b) If the internal field MaxLoadAWT is changed to non-zero, this field is the concurrent job limit for only two utilities: FastLoad and MultiLoad.

The valid range is 0 .. 30. The default is 5.

NOTE: This field can only be set to greater than 15 if the internal field MaxLoadAWT is changed from the default of zero.

DBS Control Record - Internal Fields:

93. MaxLoadAWT (This field is not supported until V2R6.1) - Maximum number of AMP worker tasks (AWT) that concurrent FastLoad and MultiLoad jobs can use altogether. The valid range is 0 .. (60% of maxampworkertasks). If the value is zero, this AWT limit check is not performed. The default is zero. This field can only be set to zero if the (general flag) MaxLoadTasks is less than or equal to 15. This field also affects the behavior of the MaxLoadTasks field. If it is zero (by default), the MaxLoadTasks field is the concurrent job limit for all three utilities: FastLoad, MultiLoad, and FastExport. If it is non-zero, the MaxLoadTasks field is the concurrent job limit for only two utilities: FastLoad and MultiLoad.

Check the Utilites manual for more details.

Dieter


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

Attachments

Library

Quick Reference