Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2003 @ 15:20:11 GMT
| 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
B
processes
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.
| 
