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
- 5640 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 |
What is real time and near real time data warehousing?
What is oltp?
Find 2 highest sal from each dept who have completed 5 year in org
In your project what type of issues and errors you facing in Teradata
how to load or extract the error table data ?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
if collect stats but it show low confidence why?
Explain teradata architecture in detail with a diagram.
How to load specific no.of records using bteq, or fastload,or multiload
What is multi insert?
What is the purpose of indexes?
How to copy teradata scripts from ur remote desktop to server machine?
Teradata 
