Archives of the TeradataForum
Message Posted: Mon, 30 Mar 2004 @ 01:43:04 GMT
| 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.