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

Explain the function of data manager.

993


What is the usage of open cursor command?

1040


Mention the location where the output received from explain statement is stored.

1056


How many databases are there?

992


What is difference between isnull and coalesce?

1011


What is the syntax for seeing the columns and data types of a table in the db2 database?

1089


How to access db2 tables in mainframe?

993


what is diffrence b/w file-aid tool and file-aid utility???

4813


What is the use of dclgen in db2?

1015


What are the two types of logging in the db2 database? Explain them.

1020


What does reorg do in db2?

985


What is ibm db2 connect?

933


How do you pull up a query which was previously saved in qmf?

1101


How would the varchar column remarks defined?

1038


What is clone table?

999