Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Mar 2004 @ 01:43:04 GMT


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


Subj:   Ab-Initio and "AMP lock table overflow"
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, March 29, 2004 20:09 -->

Hello Sam (and other Ab-Initio Users),

We are on V2R5 and use Ab-Initio to load data, we have run into issues with rowhash locks when ETL developers use certain load components. Basically the system runs out of lock resources and we run into the "AMP lock table overflow" error message, which pushes active sessions into the aborting mode. This pushed some large deletes/inserts into the aborting state and wrecked havoc on the system. Have you or others run into this problem? Any pointers to avoid this is 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