Forces local or remote users or applications off the system to allow for maintenance on a server.
This command affects all database partitions that are listed in the $HOME/sqllib/db2nodes.cfg file.
In a partitioned database environment, this command does not have to be issued from the coordinator database partition of the application being forced. It can be issued from any database partition server in the partitioned database environment.
Instance. To force users off a remote server, it is first necessary to attach to that server. If no attachment exists, this command is executed locally.
>>-FORCE APPLICATION--+-ALL--------------------------+----------> | .-,------------------. | | V | | '-(----application-handle-+--)-' >--+------------+---------------------------------------------->< '-MODE ASYNC-'
This is the only mode that is currently supported.
db2 "force application ( 41408, 55458 )"
The database manager remains active so that subsequent database manager operations can be handled without the need for db2start.
To preserve database integrity, only users who are idling or executing interruptible database operations can be terminated.
After a FORCE APPLICATION has been issued, the database will still accept requests to connect. Additional forces might be required to completely force all users off.