Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Multiload and fastload session count
 
From:   Prescott, Kyle R

Mark Young wrote:

  I believe that if you specify maxsess within the mload script, it will override the control file settings.  


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