Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Jul 2001 @ 19:00:52 GMT


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


Subj:   Re: Idle Sessions Tenacity
 
From:   Michael Larkins

Hi Sudarsan:

I am going to make an assumption here, which can be dangerous, but here goes...

Since you are experiencing idle sessions, it must either be too many sessions requested in,

1. MLOAD or Fastload

OR

2. Users not doing anything

If it is the first situation, you can use the SESSIONS parameter to request fewer sessions (defaults to 1 per AMP, based on factor of 16)

The SESSIONS is a command in Fastload and an option of the .BEGIN in MLOAD and FastExport.

If it is because of users, the Dave's suggestion of Query manager is probably the way to go.


Regards,

Mike
--



     
  <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: 15 Jun 2023