 |
 |
Archives of the TeradataForum
Message Posted: Mon, 05 Apr 2004 @ 08:21:07 GMT
| Subj: | | Re: Ab-Initio and "AMP lock table overflow" |
| |
| From: | | Victor Sokovin |
| | Yes, the API load uses ANSI session mode and apparently its hardcoded, hence one cannot change it. We have asked the vendor to gives us the
flexibility to change the session mode. | |
| | The component in question does not have Utility load option which would have given the flexibility to change the session mode. | |
| | Looking to use Tpump or place a check to make sure we don't insert large number of records using the API mode. | |
I'd like to mention that it is probably not necessary to wait for the modification of the AI component or use the TPump. The API approach
is perfectly OK for a few thousand inserts or so, provided the graph includes explicit checkpoints. They will require some obvious changes in the
graph design in the area of graph restarts but this is not an extra work. Even with the modified component which would include the transaction
mode switch similar changes would have to be made. I think your Ab Initio representative should be able to advise on the details of graphs with
checkpoints. After all they apply their components to RDBMS which have only ANSI mode and should have plenty of experience with transaction
processing and checkpoints. Hope this helps.
Regards,
Victor
| |
