Dynamic Vnode Specification--Connect to Remote Node
When connecting to a remote node (using the vnode::dbname syntax), you can specify a dynamic vnode instead of a vnode name. The dynamic vnode specification includes the connection data, user authorization, and attributes that are associated with a remote node.
Note: A dynamic vnode can be used wherever a vnode is allowed, unless otherwise stated.
A dynamic vnode specification has the following format:
@host,protocol,port[;attribute=value{;attribute=value}][[user,password]]
@host
Identifies the network name or address of the node on which the remote database is located. The @ character is required because it identifies this specification as a dynamic vnode rather than a vnode name.
protocol
Identifies the network protocol to be used by the local node to connect to the remote node. For a list of protocols and their associated keywords, see the Connectivity Guide.
port
Identifies the listen address of the Vector instance on the remote node.
attribute=value
(Optional) Is one or more additional connection, encryption, and authentication attributes for the connection. For a description of each attribute and its possible values, see the Connectivity Guide.
[user,password]
Identifies the user name and password for the user on the remote system.
Note: If used, the user and password must be enclosed in brackets. For example: [Johnny, secretpwd]. They are required if you want to authenticate using the default Ingres security mechanism.
Rather than specifying [user,password] in the dynamic vnode syntax, you can use the +user=authuser syntax before the dynamic vnode specification. The +user flag causes a prompt for the password, which protects the password from exposure. For example:
sql +user=johnny @machine01,tcp_ip,II::inventory
If the +user flag is used, you cannot also specify the [user,password] option as part of the dynamic vnode.
Examples of dynamic vnode specification:
This command runs the terminal monitor (sql) and connects to node hosta using protocol tcp_ip to remote Vector symbolic port VW. The login and password are Johnny and secretpwd. The remote database name is sales_fact:
sql @hosta,tcp_ip,VW;[Johnny,secretpwd]::sales_fact
This command establishes a direct connection by using the connection_type attribute:
sql @hosta,tcp_ip,VW;connection_type=direct[Johnny,secretpwd]::sales_fact
This command will prompt for the DBMS password (the server must be configured with dbms_authentication=on). Because the +user flag is used, the [username, password] syntax cannot be specified on the dynamic vnode.
sql +user=Johnny @hosta,tcp_ip,VW::sales_fact