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...

What is lock escalation?

Answer Posted / s

When the number of row, page locks held per tablespace
exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock
is escalated to a tablespace lock

Is This Answer Correct ?    19 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you specify the isolation level?

1040


How can we read records for specific member in CL? AND rpg?

706


What are host variables in db2?

1075


How can deadlocks be resolved?

946


What is runstats db2?

1042


What is cascading rollback?

1220


When reorg is used?

1137


Explain what are the various isolation levels possible?

1047


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092


What is the physical storage length of the data types date, time, and timestamp?

1094


What is the difference between oracle and db2?

1117


What are the prerogatives?

1084


What is runstats and reorg in db2?

1308


What is load utility in db2?

1183


What are the various data types available in db2?

1099