Database Locking Levels

Question In db2 up to which level we can lock the db?

Answer: db2 can lock individual data pages, tables (in segmented tablespaces), entire tablespaces, index leaf pages, or parts of index leaf pages. The lock level is either specified in advance or ANY is specified to allow db2 to select the appropriate level of locking for itself.


This article written by Stephen Chapman, Felgall Pty Ltd.

go to top

FaceBook Follow
Twitter Follow