The default behavior is to do row level locking. If too many row locks are held DB2 will escalate the locks to a table level lock. The only control you have is to issue "LOCK TABLE" statement--see the manual. Use the snapshot monitor to view the locks currently being held.
Hi ARWinner, thank you for you quick answer. I am DBA Informix and some activities DB2. at informix when create a table exist the statement lock mode (page or row) then you can modify this lock level if you it prefers. also you can view the lock level for any table in specific.
Thank you for you quick answer, ¿in db2 exist an sequence of command for monitoring lock en tables? and any method for look the statement is executing in database?, what applications is generating the locks and what user?