Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2008 @ 13:06:46 GMT

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

Hello,

as one collegue already answered, the number of your load/unload tasks exceeded the MAXLOADTASK of DBS Control Parameter.

You can solve this problem in different ways.

1. Many Load jobs do not need many parallel sessions, you can use the SESSION command in your load script to reduce the number of parallel sessions.

2. You can use the parameter TENACITY and SLEEP either in your configuration file (we do so) or in your load script. The script will then encounter the error and wait n(=SLEEP) minutes and try again. It will try up to m (=TENACITY) hours.

With best regards

Martin Fuchs

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