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

How does DB2 determine what lock-size to use?

Answer Posted / techie

Can anyone of you explain me the below statement.

"A solution used for lock escalation in past jobs have been
to have the jobs take an explicit lock on the partition
which prevents lock escalation."

How do i take lock on the partition level, what would be
the definition for it. I googled but couldnt get any

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scrollable cursor in db2?

1122


Explain about rct in db2?

1161


How do I add a column to a table in db2?

1156


How can we retrieve the total number of records in RPG & CLLE?

707


What is the difference between using bind () and rebind () methods of naming class?

1455


What is the use of predicate?

1085


What is the maximum size of varchar data type in db2?

1175


What does db2 plan contain?

1086


Why do we bind in db2?

1273


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3203


What kind of database is db2?

1081


What is bind and rebind in db2?

1187


What is a dbrm in db2?

1076


What is database reorganization?

1183


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1534