Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2010 @ 14:54:41 GMT

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

Mark Young wrote:

There are two ways to control the number of sessions for these load utilities:

1) as stated before you have 1 session available per amp (+2 controlling process sessions)- adding these parameters into the script overrides any configuration settings of a configuration file (option 2) or the system default limits. On large amp systems this can be non-desirable ;-). However you can override as follows:

Example Fastload script

          SESSIONS 20 4;
          LOGON DBC/USER,PSWD;

Example MultiLoad script

          BEGIN IMPORT 
                WORKTABLES 
                ERRORTABLES 
                SESSIONS 10 4;

2) Another way to do this is to add configuration files to govern the process. You can consult each utility reference manual (programming considerations) for the details for each platform (z/OS, Windows, UNIX/Linux), but you can basically reference a file that has min/max session parameters, character set usage, etc.

z/OS Example:

          //JS010    EXEC PGM=MLOAD,
          //            REGION=0M
                      //MLOADCFG DD DSN=,DISP=SHR

Example (MLOADCFG DD file contents)

          MAXSESS=20
          MINSESS=4
          BRIEF=ON
          CHARSET=EBCDIC037_0E

Microsoft Windows Example

Set USER or SYSTEM Environment Variable: MLOADLIB=

Set USER or SYSTEM Environment Variable: FLOADLIB=

Contents of MLOADCFG.dat

          AMPCHECK=ALL
          BRIEF=ON
          MAXSESS=10
          MINSESS=2
          CHARSET=LATIN1252_0A

Good Luck,

Kyle Prescott

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