Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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"

Question Posted / googie


Can some one tell me the ressolution for the error. I was not able to answer this question in wipro ..

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

Post New Answer

More Teradata Interview Questions

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,

Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,

Highlight all the modes that are present under Confidence Level.

0 Answers  

what is the default character set in teradata,,?

2 Answers   IBM, TCS,

Explain the term 'primary key' related to relational database management system?

0 Answers  

what is identity columns in teradata

2 Answers   Wipro,

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

How do you see a ddl for an existing table?

0 Answers  

what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,

how many modules are there in telecome domain?how to explain the architecture?

0 Answers  

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  

For more Teradata Interview Questions Click Here
Categories