Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 20 Apr 2008 @ 09:34:32 GMT


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


Subj:   Re: Real Time Load
 
From:   Joseph D silva

Batch array is standard JDBC implementation and a good reference is the Sun Java documentation ...

Fastload mode is switched on by using TYPE=FASTLOAD in the connection URL , the number of sessions is specified by using the SESSIONS=n parameter in the connection string.

This automatically converts the batch array to use fastload internally. the table needs to be empty just like normal fast load and all other fastload restrictions apply.

You need to remember to set autocommit to false while using fastload mode, if you are sending the records in multiple batches... (too many records per batch may result in out of memory in the JVM.This could also cause AMP lock table overflow in the normal batch array mode)


regards

Joseph D'silva



     
  <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: 15 Jun 2023