Archives of the TeradataForum

Message Posted: Sat, 03 Apr 2004 @ 08:19:37 GMT

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

This "error" is independant of the Teradata release:

If you don't specify the number of sessions to be used by MLoad/FastLoad, those tools try to logon sessions in groups of 16, until they reach the number of AMPs in your system.

So if you got e.g. 20 AMP, there will be 32 rows in dbc.logonoff:

20 "Logon" and 12 "Logon failed".

To solve that problem you must specify

.BEGIN MLOAD .... SESSIONS xx

in your load script

or better create a configuration file (mloadcfg.dat) with MAXSESS=xx

You should try to find out the optimal number of sessions for your system, because the default of 1 session/AMP is probably to much for your multinode system (lowest PE 16377 -> at least 7 PEs)

Dieter

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