Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 19 Apr 2008 @ 15:21:54 GMT


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


Subj:   Real Time Load
 
From:   Hassinger, Bill

We are trying a real time load that is not performing as desired. The records are extracted from a mainframe ADABAS database, sent to a server that reformats the data, than uses JDBC to load the data in Teradata.

A single record from ADABAS may be reformatted to 15 sql statements for the TD server. Staff are looking for 40,000 ADABAS transactions per hour throughput and we are only achieving 15,000. Which can be hundreds of thousand TD transactions. These TD transactions can be insert or deletes ( I think they use D/I rather than updates). Some transactions can take a minute when other system load and TJ is involved.

Has anyone succeeded in real time processing with this type of volume? What tricks did you learn during implementation? Can TJ be managed or turned off for a user ( I know its dangerous)?

Any thoughts would be appreciated.



     
  <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