Connection Admin

Use this page to manage the groups of database servers that are defined in the IBM® OpenAdmin Tool (OAT) for Informix® and the server connections, and to export and import connection information in XML files.

OAT groups provide a way to manage a group of database servers and to log on to a group rather than each individual server. An OAT group defines a group of database server connections. The group is password controlled and contains connection information for each server, including the IBM Informix server information and OAT environment variables. The groups are stored in the connections database.

Current® Groups

This list displays the existing OAT groups and the number of server connections for each group. You can:
  • Edit a group: Click the group name. See Edit a Group.
  • Delete a group: Select the box in the Delete Selected column for the group, and then click Delete.
  • Display a list of the connections for a group: Click the value in the Connections column. You can then click a connection to edit it. See Edit a Connection.

Import connection information from an XML file

You can import connection information for an OAT group from an XML file. For example, you can import information that you have exported from another instance of OAT.

The information can be appended to the existing connections data or replace it. To replace the existing connections data, select Remove all existing connection information.

The connections file that you import must have the same format as the connections files exported by OAT. See XML file format.

Export connection information to an XML file

You can export connection information from an OAT group to an XML file and then import it into another instance of OAT.

By default, the exported information does not include the OAT group user name and password. To include the user name and password, select Include sensitive password information in exported XML file.

XML file format

The XML file consists of three tags:

  • connections: This tag contains the entire set of connection information.
  • group: These items correspond to the fields on the Add a Group page. See Add a Group.
    • name: group name
    • password
    • readonly: 1 for yes or 0 for no
  • row: This tag is contained by the group tag. The items correspond to the fields on the Add a Connection page. See Add a Connection.
    • dbsvrnm: database server name
    • hostname
    • port
    • username
    • latitude
    • longitude
    • password

Example XML connections file

This example of an XML connections file has three groups, including the default group, which contains any connections that are not assigned to a specific group. In this example, each group has four database servers.

<connections> 

<group name="grp1" password="abcde" readonly="1"> 
<row dbsvrnm="grp1_server1" hostname="localhost" port="9001" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp1_server2" hostname="aname.com" port="9002" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp1_server3" hostname="localhost" port="9003" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp1_server4" hostname="aname.com" port="9004" username="informix" latitude="" longitude="" password="password"/> 
</group> 

<group name="grp2" password="abcde" readonly="0"> 
<row dbsvrnm="grp2_server1" hostname="localhost" port="9005" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp2_server2" hostname="aname.com" port="9006" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp2_server3" hostname="localhost" port="9007" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="grp2_server4" hostname="aname.com" port="9008" username="informix" latitude="" longitude="" password="password"/> 
</group> 

<group name="Default" password="password" readonly="1"> 
<row dbsvrnm="cheesecake1" hostname="localhost" port="9009" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="cheesecake2" hostname="aname.com" port="9010" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="cheesecake3" hostname="localhost" port="9011" username="informix" latitude="" longitude="" password="password"/> 
<row dbsvrnm="cheesecake4" hostname="aname.com" port="9012" username="informix" latitude="" longitude="" password="password"/> 
</group> 
 
</connections>
Copyright© 2018 HCL Technologies Limited