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
- 5637 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 |
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Discuss the advantages of using partitioned primary index in a query?
how do you handle ET and UV errors ?
What is a pseudo key? What is its use???
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
what is object level locking ? where do appear this type of locking ?
What is spool space? Why do you get spool space errors?
How to view every column and the columns contained in indexes in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
why varchar takes 2 extra bytes?
What does Amp contain and what are all the operations that it performs?
Teradata 
