Archives of the TeradataForum
Message Posted: Sat, 03 Apr 2004 @ 08:19:37 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|