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
- 5455 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
What is a sparse index?
What is meant by a node?
Explain the term 'database' related to relational database management system?
What are the enhanced features in teradata v2r5 and v2r6?
What is smp and mpp platforms?
During the Display time, how is the sequence generated by Teradata?
List out some of the primary characteristics of teradata.
How do you see a ddl for an existing table?
what is object level locking ? where do appear this type of locking ?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What do you mean by tpt in teradata?
How many types of joins are there in teradata?
If RDBMS is halted what will you do ?
What do you mean by caching in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
