Archives of the TeradataForum

Message Posted: Thu, 06 Jan 2011 @ 14:13:15 GMT

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

Sami,

The # of load utility varies depend if you've enable utility throttle (TASM).

1. Without Utility Throttle enabled in TASM

- If MaxLoadAWT = 0 Then

MaxLoadTask could be set from 0 - 15, as the concurrent number of jobs for FASTLOAD/MULTILOAD/FASTEXPOR

If MaxLoadAWT > 0 Then

MaxLoadTask could be set from 0 - 30, as the concurrent number of jobs for FASTLOAD/MULTILOAD. (Note - FASTEXPORT is not limited by MaxLoadTask under this configuration, but 60 - MaxLoadTask)

FASTLOAD and MULTILOAD could run up to 30 concurrently and is limited by the MaxLoadAWT.

Both MaxLoadAWT and MaxLoadAWT are available in DBSControl

2. With Utility Throttle enabled in TASM

- Utility Throttle in TASM

FastLoad: 30 Max
MultiLoad: 30 Max
FastLoad+MultiLoad: 30 Max
FastLoad+MultiLoad+FastExport: 60 Max

Hope this help.

Regards,

YB
T&O-BICC
DBS Bank Ltd

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