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 is bind package and plan in db2?

0 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,


how to fetch multiple records without using cursor

14 Answers   HCL,


B37 abend during spufi?

0 Answers   IBM,


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Describe major components of db2?

0 Answers  


How to view db2 table structure?

0 Answers  


What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,


Comment whether the cursor is closed during commit or not.

0 Answers  


What is a result table?

1 Answers  


Categories