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
- 5562 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
Can you connect multiload from ab initio?
What are the various indexes in teradata?
What do you mean by ttu in teradata?
Define views in teradata with syntax.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
How many types of joins are there in teradata?
What are the various etl tools in the market?
What are types of partition primary index (ppi) in teradata?
Different phases of multiload?
What are the main components of teradata system?
What is the use of teradata system software?
List the logical and conditional operators that are used with teradata along with their meanings?
Highlight a few of the advantages that ETL tools have over Teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain Teradata performance tuning and optimization?
