关于informix网络连接的设置 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

一、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
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />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设置

 

<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" />

 

 

 

 

 

 
 
ILogin设置

 

 

 

linux数据库主机名：informix 

informix数据库服务器名称：demo_on

informix数据库名称：stores_demo

相关命令:

onmonitor  查看数据库状态

onstat  --    查看数据库版本