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"
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 |
Explain parsing engine in teradata?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
How can bottlenecks be identified?
How to cast date "2015-03-03-012204-000000" to timestamp
What are the functions of a Parser?
how can we analyze the locks ?
What are tpump utility limitations?
What is upsert statement in teradata?
What is inner join and outer join?
What are the primary characteristics of the Teradata.
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
What is the difference between SI and JI?