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
- 5528 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.
What are the different functions included in the server software?
Explain teradata architecture in detail with a diagram.
Explain vproc in teradata?
What are the scenarios in which full table scans occurs?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is the difference between teradata and oracle?
How is MLOAD Teradata Server restarted after execution?
What are the advantages of teradata?
Explain teradata vs. Redshift?
Define views in teradata with general syntax.
What exactly do you know about catching in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What does Amp contain and what are all the operations that it performs?
Did you write stored procedures in teradata?
