1.

As you know there are different sizes of locks. Can you tell how DB2 decides which lock size should be used?

Answer»

The lock size is determined by three methods. These methods are:

  • The lock size can be DECIDED based on the lock size given while creating a NEW TABLESPACE.
  • Also, Programming DIRECTS DB2 about the lock size.
  • If the lock size ANY is specified, then DB2 (in most of the cases) CHOOSES the lock size of PAGE.


Discussion

No Comment Found

Related InterviewSolutions