Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    13

    Question Unanswered: SQL1096N The command is not valid for this node type

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    try ATTACH TO Instance

    Greetings
    Norbert

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Norbert B., can you please write full sintax.

    Grofaty

  4. #4
    Join Date
    Oct 2003
    Posts
    2
    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---------------------------------------

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •