Archives of the TeradataForum
Message Posted: Tue, 09 Jul 2001 @ 19:00:52 GMT
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
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|