Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview.
"The transaction exceeded the maximum number of rowhash locks allowed"
Answer / dotnetchampion
This error is returned when a transaction has exceeded the number of rowhash locks allowed. The threshold on the number of rowhash locks allowed is defined in DBSControl via the General field ’MaxRowHashBlocksPercent’. This is done so that one transaction does not fill up the lock table with rowhash locks. The number of control blocks/locks that can fit into an AMP lock table is defined by STDMAXLOCKBLOCKS which is currently ~51860.
Is This Answer Correct ? | 0 Yes | 0 No |
Why teradata is used?
Why is the case expression used in teradata?
What are the primary characteristics of the Teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Difference between stored procedure and macro?
How a Referential integrity is handled in Teradata?
Explain PDE.
How would you load a very large file in teradata in general?
What is the basic syntax for teradata select statement?
what is object level locking ? where do appear this type of locking ?
what is the difference between filter and router transmissions
Why does varchar occupy 2 extra bytes?