How to avoid table and row locking in DB2
To limit or avoid row locking in DB2, do the following:
1. Set the auto-commit option to Yes on the connection profiles window when connecting to the database.
2. Set the Transaction Isolation level to the lowest level, Read Uncommitted, in the Transaction Isolation dropdown on the connection profiles window when connecting to the database.
3. If table or row locking still occurs, there is a preference entitled "Close Resultsets on Execute" in the Edit - Preferences menu. Check the box next to this preference, and adjust the fetch size upwards to make sure enough rows are returned for each query for your needs.