15.00 - 2723 Too many Locks used by 2PC transactions. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

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