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 |
Explain and compare pros and cons of start schemas?
What are some primary characteristics of teradata?
What is node? How many nodes and amps used in your previous project?
What are the main components of teradata system?
What are differences between teradata and ansi session modes in teradata?
How to cast date "2015-03-03-012204-000000" to timestamp
teradata support to automatically increase the character length or not?
Why do Hash joins usually perform better than Merge Joins?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How do you set the session mode parameters in bteq?
How will you solve the problem that occurs during update?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?