Interested to Buy Any Domain ? << Click Here >> for more details...
The transaction exceeded the maximum number of rowhash locks allowed
- 1 Answers
- 10984 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / sughesh
This is error message for error :9128. 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.We can reduce the number of rowhash locks that the transaction is acquiring. An alternative is increase the General Field ’MaxRowHashBlocksPercent’ value in DBSControl.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the newly developed features of Teradata?
Explain the teradata primary index mechanics in detail with a diagram.
wt r before journal& after journel.....in teradata
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
What are the updated features of teradata?
List out some of the primary characteristics of teradata.
If the script is aborted. why it is aborted and how can you identify ?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
What do you mean by fastexport in teradata?
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
What are the available join types in teradata?
What is stored procedure in teradata?
Teradata 
