Archives of the TeradataForum

Message Posted: Fri, 25 Jul 2008 @ 13:44:36 GMT

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

I would imagine if you looked at the Freemem chart in the Higa Reports, you will see Freemem dropped very low -- perhaps even to 0 at that time.

One of the most common reasons this occurs, from what I have seen at least, is when load jobs do not specify a SESSIONS parameter, and the system defaults to 1 session per amp.

If you have 5 or 10 kicking off like that, it may be the culprit.

I would first validate that you are specifying a SESSIONS parameter in all of those load jobs. I'm sure someone knows better than me what a good starting number is, but if it were me I would try starting with around 10 SESSIONS and adjust from there.

Steve Woodrow
Teradata PS Americas
Performance & Workload Management COE

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