E-mail : support@tech2now.in

How to force close all connections in DB2

Db2 Database

FORCE APPLICATIONS ALL will forcefully terminate all connections, regardless of whether they are actively executing a transaction or not. It is important to use this command with caution, as it can result in data loss if there are any uncommitted transactions. Therefore, it is recommended to only use this command when necessary and to ensure that all active transactions have been committed.

Connect to the DB2 database:
$db2 connect to

This closes all connections between the application and the database

$db2 FORCE APPLICATIONS ALL

Verify that all connections have been closed by running the

$db2 LIST APPLICATIONS