Teradata Database Message 2723 - 2723 - Analytics Database - Teradata Vantage

Message

Too many Locks used by 2PC transactions.

Explanation

During a COLDWAIT restart, the number of locks for in-doubt 2PC transactions to be placed on a catch-up AMP to bring it on-line exceeded the lock manager lock resources.

Generated By

AMP

For Whom

Operator. DBA.

Notes

This error causes a COLD restart of the DBC to bring the system back up, but the catch-up AMP will not be on line.

Remedy

Resolve the in-doubt 2PC transactions, then COLDWAIT restart the DBC if the AMP must be brought on-line immediately.