關于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

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