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
- 5634 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
if collect stats but it show low confidence why?
Describe the set operators in teradata.
How to view every column and the columns contained in indexes in teradata?
What is meant by a Parsing Engine?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Where is teradata rdbms used?
What is the syntax for case when statement?
What is the purpose of joins in teradata?
What are the different table types supported by teradata?
Difference between inner join and outer join?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is oltp?
What type of indexing mechanism do we need to use for a typical data warehouse?
Highlight a few of the advantages that ETL tools have over Teradata.
