Archives of the TeradataForum
Message Posted: Sat, 19 Apr 2008 @ 15:21:54 GMT
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.
|