Hi,

As I want to kill all connections to the database, I got the following error message when I run the command "db2 force application all" in a client machine. However, the command is running successfully in the server machine. Would anyone tell me how can I solve this problem or any other ways to kill user connections by a client machine rather than a server machine?

db2 => force application all
SQL1096N The command is not valid for this node type.
db2 =>

Thank you!
Vincent

try ATTACH TO Instance

Greetings
Norbert

Hi,

Norbert B., can you please write full sintax.

Grofaty

see DB2 Command-Reference:

ATTACH Command
Enables an application to specify the instance at which instance-level commands (CREATE DATABASE and FORCE APPLICATION, for example) are to be executed. This instance may be the current instance, another instance on the same workstation, or an instance on a remote workstation.

Authorization

None

Required connection

None. This command establishes an instance attachment.

Command syntax

>>-ATTACH--+--------------+------------------------------------->
'-TO--nodename-'

>--+---------------------------------------------------------------------------+-><
'-USER--username--+-------------------------------------------------------+-'
+-USING--password--+----------------------------------+-+
| '-NEW--password--CONFIRM--password-' |
'-CHANGE PASSWORD---------------------------------------

If you don't have a database on the client then I don't understand why you want to run force applications on the client. If you are trying to force of users connected to a database from a client then you require an instance attachment and then use the command above (attach) before you issue the force. Otherwise, just issue it on the server.