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
- 5454 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 the Maximum number of volatile tables that can be created?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
Does SDLC changes when you use Teradata instead of Oracle?
How many types of index are present in teradata?
How do you define Teradata?
Can we load a Multi set table using MLOAD?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
What do you mean by teradata intelliflex?
How to run the Teradata jobs in unix environment ???
what happen if a query fail in dispatcher?
What is the process to restart the multiload if it fails?
Teradata 
