Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2003 @ 15:20:11 GMT

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

Subj:   Re: Max Load Tasks
From:   Ian Russell

Another angle to look at....

We have our MaxLoadTasks set to 10. Tenacity normally copes with any situation where more than 10 utilities are trying to run. However, at the start of this month (1st March - end of the week, start of the month and because it was a short month we had a intensive process running as well) we ran out of sessions to allow logon to our 5200 from one of the IBM's that connects to it.

The IBM in question has 16 channels connecting it to the 5200 with 24 Parsing Engines associated with it. You can have 120 sessions per PE. Teradata has an option that 1 PE's 120 sessions are held in reserve so that if there were issues the system could still log on. We have a limit on the number of utilities (FLOAD, etc) that can run at any one time on Teradata to 10. So....

16 Channels
24 PE's * 120 sessions per PE = 2880 total sessions available for Block
Utility limit is 10 * 280 sessions = 2800 total utility sessions
Session Reserve = 120

2880 - 2800 - 120 = -40

We have requested that the business area coming in from the specific IBM limit the number of sessions on their Fast Load jobs rather than allowing them to default to 280.

  <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: 28 Jun 2020