Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 Jun 2004 @ 10:53:09 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Session Limits on Loads
From:   Coffing Christopher L


Just a quick request for your brain trust on the number of sessions to place in MLOAD jobs.

We have several of our ETL jobs that are using 50 sessions in their MLOADs. This is taking up a lot of the systems resources and I have been discussing this with the ETL team requesting that they decrease the Session number.

The response is "It makes the loads faster." I am sure there is a point of diminishing returns so I ask you this. What is a common practice for setting sessions for the load utilities? Should Sessions be left out of the MLOAD script so they default to MAX? and how is MAX calculated if the Sessions = (n) is not part of the script?

I will keep digging around in my spare time (which I have so much of) to find more information on this subject but I could use some of that "been there, done that" expertise.

Looking forward to your input.

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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