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
- 5563 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 |
which option is used to restart the fast load script?
Can you connect multiload from ab initio?
What is the opening step in basic teradata query script?
How does hashing happens in teradata?
What is meant by a dispatcher?
What are the advantages of teradata?
How do you Generate Sequence in Teradata?
What is a three-tier data warehouse?
What is basic teradata query language?
Highlight the advantages of PPI(Partition Primary Index).
What are the joins in teradata and how many types of joins are there in teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Teradata 
