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 Posted / 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 |
Post New Answer View All Answers
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What happens in a conflict? How do you handle that?
What is collect statistics?
Describe primary index in teradata. And what are the available primary index types?
What are the joins in teradata and how many types of joins are there in teradata?
What is meant by a Highest Cost Plan?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is node? How many nodes and amps used in your previous project?
What is the difference between teradata and basic rdbms?
Discuss the advantages of using partitioned primary index in a query?
What do you mean by teradata intellicloud?
What are the advantages of teradata?
Difference between multiload and tpump?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is the use of virtual processor connectivity in teradata?