onSqlHostTable
The following list summarizes this table:
- Contents:
- Copy of the connection information
- Index:
- applIndex, onSqlHostIndex
- Scope of a row:
- One connectivity value
As the following table shows, the location of the connection
information depends on the operating system.
| Operating system | Location of connectivity information |
|---|---|
| UNIX | The INFORMIXSQLHOSTS environment variable specifies the full path name and file name of the connection information. The default location is $INFORMIXDIR/etc/sqlhosts. For information about INFORMIXSQLHOSTS, see the IBM® Informix Guide to SQL: Reference. |
| Windows | The connectivity information is in a key in the Windows registry called HKEY_LOCAL_MACHINE\SOFTWARE\Informix\SQLHOSTS. |
For details about the connection information, see your IBM Informix Administrator's Guide.
The table has the following MIB objects.
| MIB object | Description |
|---|---|
| applIndex | See applTable. |
| onSqlHostIndex | Index to the entry in the connectivity information |
| onSqlHostName | Host name of the database server |
| onSqlHostNetType | Connection type |
| onSqlHostServerName | Name of the database server or its alias |
| onSqlHostServiceName | Service name |
| onSqlHostOptions | List server options in the form of key=value pairs |