Look for Concurrency Bottlenecks
The Blocking Lock Display helps locate bottlenecks in the database.
To look for concurrency bottlenecks
1. Run IPM on the desired database, and display the Lock List Display.
2. Tab to the Status column and select the Find menu item.
The String to search for prompt appears.
3. Enter WAIT.
4. Select the Block_Info menu item if a waiting lock list is found.
The blocking lock is found if it is in the locking system in the current installation on the machine where IPM is running.
Note: If you are searching for a lock on another node in the cluster, the lock may not be visible on the current node. To find the lock, run IPM on the other nodes.