Archives of the TeradataForum

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

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

<-- 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>>