In DB2 locking is very important to improve performance. How DB2 applies lock, a programmer also can control which lock to take. This is just an awesome information with examples and PPT on DB2 locks.
Here is how DB2 applies Locks while accessing data. A detailed relation for Concurrency and Locks in DB2