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?

Answers were Sorted based on User's Feedback



How does DB2 determine what lock-size to use?..

Answer / s

LOCKSIZE is defined with the CREATE TABLESPACE DDL.

Is This Answer Correct ?    13 Yes 1 No

How does DB2 determine what lock-size to use?..

Answer / 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

More DB2 Interview Questions

What does it mean if the null indicator has -1, 0, -2?

1 Answers  


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  


What is an inner join, and an outer join ?

1 Answers   CTA,


What is the command used by TSO users to invoke DB2?

2 Answers   IBM,


What is database reorganization?

0 Answers  


what is rebinding ?

1 Answers   IBM,


Why db2 is called db2?

0 Answers  


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


What are the 4 environments which can access DB2 ?

2 Answers  


What is consistency token in db2?

0 Answers  


What is dbrm in db2 database?

0 Answers  


Comment whether the cursor is closed during commit or not.

0 Answers  


Categories