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
- 4700 Views
- Wipro, I also Faced
- E-Mail Answers
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
Define views in teradata with syntax.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are the functions of a Parser?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between teradata and oracle?
Highlight the limitations of TPUMP Utility.
During the Display time, how is the sequence generated by Teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the meaning of Caching in Teradata?
What are the available primary index types in teradata.
how can we analyze the locks ?
What is real time and near real time data warehousing?
In general, how do you optimze any sql in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain vproc in teradata?
