Clearing Locked Applications in DB2

NewPush TeamAuthor

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.

Security Check

Please complete this brief challenge to submit your request. This helps us prevent spam.