Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2003 @ 15:20:11 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|