Archives of the TeradataForum
Message Posted: Sat, 19 Apr 2008 @ 15:21:54 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|