Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2004 @ 08:21:07 GMT

  <Prev Next>   <<First <Prev

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023