Finding and Killing Sessions in DB2 LUW (Linux / Unix / Windows)
The first step in killing a session in a DB2 LUW database is to find the session to kill. Be sure to connect to DB2 as a user that has the privileges necessary to run queries to find sessions and execute commands to kill sessions. The following query will list running sessions in a DB2 database.
SELECT
APPLICATION_HANDLE,
CLIENT_IPADDR,
CLIENT_PORT_NUMBER,
SESSION_AUTH_ID,
CURRENT_SERVER,
APPLICATION_NAME,
CLIENT_PROTOCOL,
CLIENT_PLATFORM,
CLIENT_HOSTNAME,
CONNECTION_START_TIME,
APPLICATION_ID,
EXECUTION_ID
FROM
TABLE(MON_GET_CONNECTION(cast(NULL as bigint),
-2))
ORDER BY
APPLICATION_HANDLE;
The value from the result of the above query that is needed to kill the session is the APPLICATION_HANDLE. To kill the session, execute the following command using the appropriate APPLICATION_HANDLE from the above query. In the example below, the APPLICATION_HANDLE is 774.
CALL SYSPROC.ADMIN_CMD('FORCE APPLICATION (774)');
