关于informix网络连接的设定

关于informix网络连接的设置

 

一、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  --    查看数据库版本

 

 

 

 本文转自 pgmia 51CTO博客，原文链接:http://blog.51cto.com/heyiyi/123535