1. Open the monitor window DB2 UPDATE MONITOR SWITCHES USING LOCK ON
2, run the program for a while
DB2 Get Snapshot for Locks ON Database Name You can view all application handles that are currently connected to the database, while each of each connection is locked