Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Jun 2010 @ 12:32:57 GMT


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


Subj:   Re: Multiload and fastload session count
 
From:   Geoffrey Rommel

Hold on here! The original question was "what is the max session number for fastload and multiload?" The replies so far, however, have been about the total number of load jobs running on the system. MaxLoadTasks etc. are DBS Control parameters and should NOT be changed unless you have a good reason.

Sessions are different. Each load job uses a certain number of sessions, and that number can be different for each job. If you don't specify a number, the load utilities will query the target system to find out how many AMPs it has and start that many sessions; for instance, if you have 48 AMPs, it will start 48 sessions. This number is usually much too large; 6-8 sessions do all the work and the others sit idle. I recommend loading the same data repeatedly with differing numbers of sessions and timing the jobs. You will probably find that the optimal number of sessions is about 1/10 the number of AMPs.

The *maximum* number of sessions on a system is determined by the number of Parsing Engines. Each PE can handle 120 sessions, so if you have 4 PE's you can have a total of 480 sessions. (Again, this can be changed but usually shouldn't be.) The systems are sized so that you will probably never reach this limit, but if you do you'll get one of my favorite errors, 8024: "All virtual circuits are currently in use."



     
  <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