Toad sessions are blocking each other. The client sessions are set to autocommit. The sessions are running updates by executing dynamic update statements. Sometimes the locks are on catalog tables too.
WORKAROUND:
Set options on Toad for DB2 to prevent locks:
1. Set Limit Rows Return: Tool | Options | Browser | General
This preference states how many rows to fetch in Data Tab of browser. It will fetch N rows and then close cursor. This is not fetch on demand. In DB2 this causes to locks.
2. Check mark on Unlimited for Number of rows to initially fetch from a query. Also check mark on AutoCommit: Tool | Options | Database | General
This workaround decreases the frequency of locking up. It doesn't guarantee it will never get lock again.
