Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Invisible Login Error
From:   Dieter Noeth

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


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)


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023