Interested to Buy Any Domain ? << Click Here >> for more details...
The transaction exceeded the maximum number of rowhash locks allowed
- 1 Answers
- 11020 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 |
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the different table types supported by teradata?
How is Teradata in current market?
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
what are the default access rights in the teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How do you Generate sequence at the time of Display?
Explain the new features of teradata?
What is use of compress in terdata?Explain?
Highlight the points of differences between the database and user in Teradata.
Hash collision?
Teradata 
