Archives of the TeradataForum
Message Posted: Fri, 10 Mar 2006 @ 16:46:59 GMT
| Subj: | | Re: MLoad session calculations |
| |
| From: | | Rodrigo Cifuentes |
This limit (Load/Unload) is not related to sessions, but to the number of concurrent load utilities you can run. By default, the max is 15.
To allow more than that (which I would not recommend) a DBA has to change Teradat configuration.
The number of sessions you can open concurrently is 120 by PE. You can ask the number of PEs in your config to your DBA.
MLOAD uses by default #AMPS sessions plus 1, and this is usually enough, given the way MLOAD loads the data.
Rodrigo Cifuentes
3nergy Ltda
| 
