Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

.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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023