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
- 5458 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 |
Describe the between keyword in teradata?
What happens when a node suffers a downfall?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
what is DYNAMIC SQL in TD?
What is TPD?
Is multi insert ansi standard?
Highlight a few of the important components of Teradata?
Highlight all the modes that are present under Confidence Level.
Comment whether bottleneck is an error or not.
Explain teradata utilities. What is multiload, fast load, tpump?
If a Node is busy what are the steps you can take to avoid ?
What are the newly developed features of Teradata?
Teradata 
