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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is lock escalation?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is lock escalation?..

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

What is lock escalation?..

Answer / andank

The Answer # 1 is perfect. When Lock esculation happens,
DB2 issues a warning message, DSNI031I.

Please beaware Lock Escalation and Lock Promotion are two
different concepts.

Lock promotion is the action of exchanging one lock on a
resource for a more restrictive lock on the same resource,
held by the same application process.

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More DB2 Interview Questions

What is concurrency in db2?

1 Answers  

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

how will you retrieve first record in table

1 Answers   UST,

How to create db2 table in mainframe?

0 Answers  

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

How can you find out the # of rows updated after an update statement?

0 Answers  

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

What are the various isolation levels possible?

0 Answers  

Before you give the explain statement, what are the prerogatives?

0 Answers  

For more DB2 Interview Questions Click Here
Categories