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:

LIST APPLICATIONS;FORCE APPLICATION (<application number>);

The application number can be a comma-separated list.