Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 1 Answers
- 5536 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
In the Primary Index, what is the score of AMPs that are actively involved?
How is Teradata in current market?
Fast Load Script is failed and error tables are available then how do you restart?
What is collect statistics?
How a Referential integrity is handled in Teradata?
What is meant by a node?
What is differnce between Error code and Error Level in Bteq
What tools would you use for that?
What are the different functions included in the server software?
What is multi insert?
What are the frequently used data types in teradata?
Teradata 
