Clearing Locked Applications in DB2

When developing queries and stored procedures, it is possible to lock up access to the database. This can happen most frequently when autocommit is off, and a transaction is left hanging in a window.  If all else fails, the application that is causing the lockup can be identified and forced with:

FORCE APPLICATION (<application number>);

The application number can be a comma-separated list.