一、Linux数据库端设置

1. /opt/informix/etc/sqlhosts文件

[informix@informix ~]$ vi /opt/informix/etc/sqlhosts

#**************************************************************************

#

# Licensed Material - Property Of IBM

#

# "Restricted Materials of IBM"

#

# IBM Informix Dynamic Server

# (c) Copyright IBM Corporation 1996, 2004 All rights reserved.

#

# Title: sqlhosts.demo

# De.ion:

# Default sqlhosts file for running demos.

#

#**************************************************************************

# IANA ([url]www.iana.org[/url]) assigned port number/service names for Informix:

# sqlexec 9088/tcp

# sqlexec-ssl 9089/tcp

#INFORMIXSERVER PROTOCOL HOSTNAME SERVICE_NAME

demo_on onsoctcp informix sqlexec

#demo_se seipcpip se_hostname sqlexec

2. /etc/hosts文件

[informix@informix ~]$ vi /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

10.8.1.240 informix

3. /etc/services文件

[informix@informix ~]$ vi /etc/services

sqlexec 5000/tcp

4. /opt/informix/etc/onconfig文件

NETTYPE soctcp,1,50,CPU

二、windows设置

C:\WINDOWS\system32\drivers\etc目录下的两个文件hosts，service

1.Hosts文件

# Copyright (c) 1993-1999 Microsoft Corp.

#

# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.

#

# This file contains the mappings of IP addresses to host names. Each

# entry should be kept . an individual line. The IP address should

# be placed in the first column followed by the corresponding host name.

# The IP address and the host name should be separated by at least .e

# space.

#

# Additionally, comments (such as these) may be inserted . individual

# lines or following the machine name denoted by a '#' symbol.

#

# For example:

#

# 102.54.94.97 rhino.acme.com # source server

# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost

10.8.1.240 informix

2.services文件

man 9535/tcp #Remote Man Server

sqlexec 5000/tcp

2. 安装informix client SDK

Setnet32设置

ILogin设置

linux数据库主机名：informix

informix数据库服务器名称：demo_on

informix数据库名称：stores_demo

相关命令:

onmonitor 查看数据库状态

onstat -- 查看数据库版本