Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2008 @ 13:06:46 GMT


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


Subj:   Re: RDBMS error 2633: Too many load/unload
 
From:   martin.fuchs

Hello,

as one collegue already answered, the number of your load/unload tasks exceeded the MAXLOADTASK of DBS Control Parameter.

You can solve this problem in different ways.

1. Many Load jobs do not need many parallel sessions, you can use the SESSION command in your load script to reduce the number of parallel sessions.

2. You can use the parameter TENACITY and SLEEP either in your configuration file (we do so) or in your load script. The script will then encounter the error and wait n(=SLEEP) minutes and try again. It will try up to m (=TENACITY) hours.


With best regards

Martin Fuchs



     
  <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: 27 Dec 2016