Amp lock table overflow.

UDA
Enthusiast

Amp lock table overflow.

Hi All,
I am using informatica to load data from MSSQL tables to Teradata.

This is the error that I am getting while loading data into a few table

WRITER_1_*_1> WRT_8229 Database errors occurred:
FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata RDBMS] The AMP Lock table has overflowed.

What is an AMP LOCK TABLE and what causes an overflow.
Did any one come across this error either while using informatica or while using the load utilities?

I'd appreciate your help.

Thanks

1 REPLY
Enthusiast

Re: Amp lock table overflow.

Found the cause:
Too many transactions running at the same time.