Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Paging and Memory Allocation Fails
From:   Woodrow, Steven

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