Edit a Connection

Use this page to edit the connection information in an OAT group entry.

OAT group name

Select the OAT group that the connection belongs to.

Informix server

Enter the name of the database server to connect to.

Informix host name

Enter the name of the computer where the database server is installed.

Informix port

Enter the port number of the computer where the database server is installed.

idsd port

Optional: To enable starting and stopping servers in high availability clusters, enter the idsd service port number. The number is specified in the /etc/services file on the database server. For example: idsd 10000/tcp.

Connection protocol

Select the type of connection to the database server (nettype on UNIX, or PROTOCOL on Windows):

Table 1. Summary of nettype and protocol values

UNIX or Linux: nettype value from the sqlhosts file	Windows: protocol value in the SQLHOSTS registry key	Description
ontlitcp		TLI (transport layer interface) with TCP/IP protocol
onsocssl	onsocssl	Secure Sockets Layer (SSL) protocol
onsoctcp	onsoctcp	Sockets with TCP/IP protocol

Informix user name

Enter the user name for the database server. You can specify user informix or a user who is a member of the operating system Database Server Administrator (DBSA) group. If a user has privileges to run the SQL administration API commands on the database server, you can enter that user name and password.

If the user is a tenant database owner, select Tenant DB owner and enter the name of the database.

Informix Password

Enter the valid password for the user specified in the User name field.

Environment variables

Click View/Modify.

• To define a new environment variable, enter the Variable Name and Value, and click Add.
• To delete an environment variable, click Delete.
• To hide the list of environment variables, click Collapse.

To test a connection, click Test Connection.

To save connection information changes, you must click Save Changes.