The transaction exceeded the maximum number of rowhash locks allowed
- 1 Answers
- 10492 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 |
How many types of joins are there in teradata?
Mention a few of the ETL tools that come under Teradata.
what is DYNAMIC SQL in TD?
what is the difference between start schma and Fsldm?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
Explain about Skew Factor?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is partitioned primary index (ppi)?
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
What do you mean by ttu in teradata?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
Teradata 
