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
- 5577 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 |
I want to write one query How to get Matched records and unmatched records in table?
What type of indexing mechanism do we need to use for a typical data warehouse?
How to relege locks in fastload and multiload? example?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
What is the difference between fastload and multiload?
What is the meaning of Caching in Teradata?
How do you Generate Sequence in Teradata?
Difference between inner join and outer join?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
Why do Hash joins usually perform better than Merge Joins?
can we join volatile table with general table an global temporary table with general table ?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Teradata 
