在linux環境_centos4_5_中安裝informix 11_5

幾乎完全參考《Informix install in linux as4 u5 》地址為：
http://hehehe.blog.51cto.com/205455/121815[@more@]

以下為操作的全部過程，其中標紅色的為輸入

Last login: Sun Aug 2 17:41:17 2009
[root@localhost ~]# groupadd -g 101 informix [root@localhost ~]# useradd -g 101 -d /opt/informix -m informix [root@localhost ~]# passwd informix Changing password for user informix.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@localhost ~]# vi /opt/informix/.bashrc

# .bashrc

# User specific aliases and functions

# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
INFORMIXSERVER=mydbsn
INFORMIXDIR=/opt/informix
ONCONFIG=onconfig.mydbsn
PATH=/bin:/usr/bin:/usr/sbin:/usr/ucb:/etc:$INFORMIXDIR:$INFORMIXDIR/bin:$INFORMIXDIR/etc:$PATH
export INFORMIXSERVER
export INFORMIXDIR
export ONCONFIG
export PATH "/opt/informix/.bashrc" 16L, 363C written
[root@localhost ~]# cd /opt/informix [root@localhost informix]# mkdir original [root@localhost informix]# cd o* [root@localhost original]# ftp 10.31.1.20
Connected to 10.31.1.20.
220 Microsoft FTP Service
500 'AUTH GSSAPI': command not understood
500 'AUTH KERBEROS_V4': command not understood
KERBEROS_V4 rejected as an authentication type
Name (10.31.1.20:root): anonymous 331 Anonymous access allowed, send identity (e-mail name) as password.
Password:
230 Anonymous user logged in.
Remote system type is Windows_NT.
ftp> bin 200 Type set to I.
ftp> ls 227 Entering Passive Mode (10,31,1,20,13,175).
125 Data connection already open; Transfer starting.
06-04-09 08:26PM 216596480 iif.11.50.UC4DE.Linux-RHEL4.tar
08-02-09 11:29AM 9931969 powerdesign.chm
226 Transfer complete.
ftp> get iif.11.50.UC4DE.Linux-RHEL4.tar local: iif.11.50.UC4DE.Linux-RHEL4.tar remote: iif.11.50.UC4DE.Linux-RHEL4.tar
227 Entering Passive Mode (10,31,1,20,13,176).
125 Data connection already open; Transfer starting.
226 Transfer complete.
216596480 bytes received in 42 seconds (5e+03 Kbytes/s)
ftp> quit 221
[root@localhost original]# tar -xvf iif.11.50.UC4DE.Linux-RHEL4.tar
CSDK/
CSDK/UNIX/
CSDK/UNIX/csdk.jar
CSDK/UNIX/doc/
CSDK/UNIX/doc/client_relnotes_3.50.html
CSDK/UNIX/doc/client_relnotes_3.50.txt
CSDK/UNIX/doc/cmsm_relnotes_3.50.html
CSDK/UNIX/doc/cmsm_relnotes_3.50.txt
CSDK/UNIX/doc/esqlc_relnotes_3.50.html
CSDK/UNIX/doc/esqlc_relnotes_3.50.txt
CSDK/UNIX/doc/odbc_relnotes_3.50.html
CSDK/UNIX/doc/odbc_relnotes_3.50.txt
CSDK/UNIX/doc/oledb_relnotes_3.50.htm
CSDK/UNIX/doc/oledb_relnotes_3.50.txt
CSDK/UNIX/doc/Gls_relnotes_3.50.html
CSDK/UNIX/doc/Gls_relnotes_3.50.txt
CSDK/UNIX/doc/Glsapi_machine_notes_3.50.txt
CSDK/UNIX/doc/Libcpp_machine_notes_3.50.txt
CSDK/UNIX/doc/ESQLC_machine_notes_3.50.txt
CSDK/UNIX/doc/Odbc_machine_notes_3.50.txt
CSDK/UNIX/doc/client_defects_3.50.html
CSDK/UNIX/doc/client_defects_3.50.txt
CSDK/UNIX/doc/Client_install_guide.pdf
CSDK/UNIX/doc/cpp_relnotes_3.50.html
CSDK/UNIX/doc/cpp_relnotes_3.50.txt
CSDK/UNIX/installclientsdk
CSDK/UNIX/csdk.ini
ICONNECT/
ICONNECT/UNIX/
ICONNECT/UNIX/conn.jar
ICONNECT/UNIX/doc/
ICONNECT/UNIX/doc/client_relnotes_3.50.html
ICONNECT/UNIX/doc/client_relnotes_3.50.txt
ICONNECT/UNIX/doc/cmsm_relnotes_3.50.html
ICONNECT/UNIX/doc/cmsm_relnotes_3.50.txt
ICONNECT/UNIX/doc/esqlc_relnotes_3.50.html
ICONNECT/UNIX/doc/esqlc_relnotes_3.50.txt
ICONNECT/UNIX/doc/odbc_relnotes_3.50.html
ICONNECT/UNIX/doc/odbc_relnotes_3.50.txt
ICONNECT/UNIX/doc/oledb_relnotes_3.50.htm
ICONNECT/UNIX/doc/oledb_relnotes_3.50.txt
ICONNECT/UNIX/doc/Gls_relnotes_3.50.html
ICONNECT/UNIX/doc/Gls_relnotes_3.50.txt
ICONNECT/UNIX/doc/Glsapi_machine_notes_3.50.txt
ICONNECT/UNIX/doc/Libcpp_machine_notes_3.50.txt
ICONNECT/UNIX/doc/ESQLC_machine_notes_3.50.txt
ICONNECT/UNIX/doc/Odbc_machine_notes_3.50.txt
ICONNECT/UNIX/doc/client_defects_3.50.html
ICONNECT/UNIX/doc/client_defects_3.50.txt
ICONNECT/UNIX/doc/Client_install_guide.pdf
ICONNECT/UNIX/doc/cpp_relnotes_3.50.html
ICONNECT/UNIX/doc/cpp_relnotes_3.50.txt
ICONNECT/UNIX/installconn
ICONNECT/UNIX/conn.ini
JDBC/
JDBC/setup.jar
JDBC/doc/
JDBC/doc/jdbcrel.htm
JDBC/doc/patchinfo.htm
JDBC/doc/install.txt
README.html
SERVER/
SERVER/IIF.jar
SERVER/doc/
SERVER/doc/ids_doc_notes_11.50.html
SERVER/doc/ids_doc_notes_11.50.txt
SERVER/doc/ids_machine_notes_11.50.txt
SERVER/doc/ids_unix_relnotes_11.50.html
SERVER/doc/ids_unix_relnotes_11.50.txt
SERVER/doc/notesstyle.css
SERVER/doc/ids_unix_installg_11.50.pdf
SERVER/doc/ids_defects_11.50.txt
SERVER/installserver
SERVER/server.ini
SERVER/Platform.prq
SERVER/onsecurity
bundle.ini
ids_install
images/
images/InstallGuide.jpg
images/InstallGuideActive.jpg
images/ReleaseNotes.jpg
images/ReleaseNotesActive.jpg
images/Informix_DSB_splash_screen.gif
images/QuickBgGuide.jpg
images/QuickBgGuideActive.jpg
suite.jar
.jvm.bin
[root@localhost original]# ./ids_install
Do you want to run installer in GUI mode [y/n] :
n

Initializing InstallShield Wizard........
Launching InstallShield Wizard........

1. Release Notes
2. Installation Guide
3. Launch Information Center
4. Begin Installation

Please select one of these options [4]

Beginning installation...

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

Welcome to the InstallShield Wizard for IBM Informix Dynamic Server Version
11.50 Bundle

The InstallShield Wizard will install IBM Informix Dynamic Server Version 11.50
Bundle on your computer.
To continue, choose Next.

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

International License Agreement for Non-Warranted Programs

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, OR USING THE PROGRAM
YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE
TERMS ON BEHALF OF ANOTHER PERSON OR A COMPANY OR OTHER LEGAL
ENTITY, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL AUTHORITY TO
BIND THAT PERSON, COMPANY, OR LEGAL ENTITY TO THESE TERMS. IF YOU DO
NOT AGREE TO THESE TERMS,



- DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, OR USE THE PROGRAM; AND



- PROMPTLY RETURN THE PROGRAM AND PROOF OF ENTITLEMENT TO THE PARTY

Press Enter to continue viewing the license agreement, or, Enter "1" to accept
the agreement, "2" to decline it or "99" to go back to the previous screen, "3"
Print, "4" Read non-IBM terms.

1

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

IBM Informix Dynamic Server Version 11.50 Bundle Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/IBM/informix] /opt/informix

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

Searching for products available for install: this may take a few minutes.

Select the products you would like to install:

To select/deselect a product or to change its setup type, type its number:

Product Setup Type
------------------------------------------------ ------------------------
1. [ ] IBM Informix IConnect Version 3.50
2. [x] IBM Informix Client-SDK Version 3.50 Typical
3. [x] IBM Informix Dynamic Server Version 11.50 Typical
4. [x] IBM Informix JDBC Driver Version 3.50

Other options:

0. Continue installing

Enter command [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Checking for Server Prerequisites ...

Do you want to enable role separation for auditing procedures?

[ ] 1 - Yes
[X] 2 - No

To select an item enter its number, or 0 when you are finished: [0]

If you enable role separation, you can assign existing groups of users to
specific roles.

If you do not enable role separation, the database server administrator
performs all administration tasks.

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Do you want to create an IDS demonstration database server instance?

[ ] 1 - Yes
[X] 2 - No

To select an item enter its number, or 0 when you are finished: [0]

You can use a demonstration database server instance to verify that IDS is
installed correctly and that the hardware is configured correctly. You can also
configure the demonstration database server instance to use it as a production
instance.

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

IBM Informix Dynamic Server Version 11.50 Bundle will be installed in the
following location:

/opt/informix

with the following features:

IBM Informix Client-SDK Version 3.50
IBM Informix Dynamic Server Version 11.50
IBM Informix JDBC Driver Version 3.50

for a total size:

397.9 MB

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Installing IBM Informix Client-SDK Version 3.50. Please wait...

0 % complete
10 % complete
20 % complete
30 % complete
40 % complete
50 % complete
60 % complete
70 % complete
80 % complete
90 % complete
100 % complete

Creating uninstaller...

Installing IBM Informix Dynamic Server Version 11.50. Please wait...

Creating uninstaller...

Installing IBM Informix JDBC Driver Version 3.50. Please wait...

Creating uninstaller...

Performing GSKit Installation ...
Performing GSKit installation for Linux ...

Branding Installed Files ...

Branding Files ...
Installing directory .
Installing directory etc
Installing directory bin
Installing directory lib
Installing directory lib/client
Installing directory lib/client/csm
Installing directory lib/esql
Installing directory lib/dmi
Installing directory lib/c++
Installing directory lib/cli
Installing directory release
Installing directory release/en_us
Installing directory release/en_us/0333
Installing directory incl
Installing directory incl/esql
Installing directory incl/dmi
Installing directory incl/c++
Installing directory incl/cli
Installing directory demo
Installing directory demo/esqlc
Installing directory demo/c++
Installing directory demo/cli
Installing directory doc
Installing directory doc/gls_api
Installing directory doc/gls_api/en_us
Installing directory doc/gls_api/en_us/0333
Installing directory tmp
Installing directory gsk
Installing directory gsk/client
Installing directory gskit
Installing directory gsk
Installing directory gsk/client

IBM Informix Product: IBM INFORMIX-Client SDK
Installation Directory: /opt/informix

Performing root portion of installation of IBM INFORMIX-Client SDK...

Installation of IBM INFORMIX-Client SDK complete.

Installing directory etc
Installing directory gls
Installing directory gls/cm3
Installing directory gls/cv9
Installing directory gls/dll
Installing directory gls/etc
Installing directory gls/lc11
Installing directory gls/lc11/cs_cz
Installing directory gls/lc11/da_dk
Installing directory gls/lc11/de_at
Installing directory gls/lc11/de_ch
Installing directory gls/lc11/de_de
Installing directory gls/lc11/en_au
Installing directory gls/lc11/en_gb
Installing directory gls/lc11/en_us
Installing directory gls/lc11/es_es
Installing directory gls/lc11/fi_fi
Installing directory gls/lc11/fr_be
Installing directory gls/lc11/fr_ca
Installing directory gls/lc11/fr_ch
Installing directory gls/lc11/fr_fr
Installing directory gls/lc11/is_is
Installing directory gls/lc11/it_it
Installing directory gls/lc11/ja_jp
Installing directory gls/lc11/ko_kr
Installing directory gls/lc11/nl_be
Installing directory gls/lc11/nl_nl
Installing directory gls/lc11/no_no
Installing directory gls/lc11/os
Installing directory gls/lc11/pl_pl
Installing directory gls/lc11/pt_br
Installing directory gls/lc11/pt_pt
Installing directory gls/lc11/ru_ru
Installing directory gls/lc11/sk_sk
Installing directory gls/lc11/sv_se
Installing directory gls/lc11/th_th
Installing directory gls/lc11/zh_cn
Installing directory gls/lc11/zh_tw

IBM Informix Product: Gls
Installation Directory: /opt/informix

Performing root portion of installation of Gls...

Installation of Gls complete.

Installing directory etc
Installing directory msg
Installing directory msg/en_us
Installing directory msg/en_us/0333

IBM Informix Product: messages
Installation Directory: /opt/informix

Performing root portion of installation of messages...

Installation of messages complete.

Please read the information below.

Set required environment variables
Set $INFORMIXDIR to the directory where the IDS server is installed.
Set $PATH to include $INFORMIXDIR/bin
Set $INFORMIXSERVER to the name of the database server
Set $ONCONFIG to the name of the active onconfig configuration file.
If using a sqlhosts file other than $INFORMIXDIR/etc/sqlhosts
Set $INFORMIXSQLHOSTS
If using a locale/language other than the default
Set $CLIENT_LOCALE
Set $DB_LOCALE
Set $SERVER_LOCALE
Set $DBLANG
Prepare connectivity files
sqlhosts
/etc/hosts
/etc/services
Prepare configuration file
Set DBSERVERNAME
Set SERVERNUM
Set ROOTNAME

Press ENTER to read the text [Type q to quit]

Set ROOTPATH
Set ROOTSIZE
Initialize database server
As informix or root, run oninit
If initializing a new server for the FIRST time, run oninit -i
This will overwrite any existing data, so use caution on an existing setup

For more information please refer to the IBM Informix Dynamic Server Getting
Started Guide

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

The InstallShield Wizard has successfully installed IBM Informix Dynamic Server
Version 11.50 Bundle. Choose Next to continue the wizard.

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

1. Release Notes
2. Installation Guide
3. Launch Information Center
4. Finish Installation

Please select one of these options [4]

Finishing installation...

Press 3 to Finish or 4 to Redisplay [3]

[root@localhost original]# su - informix
[informix@localhost ~]$ echo $ONCONFIG onconfig.mydbsn
[informix@localhost ~]$ cd etc
[informix@localhost etc]$ cp sqlhosts.std sqlhosts
[informix@localhost etc]$ cp onconfig.std onconfig.mydbsn [informix@localhost etc]$ vi 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
# Description:
# Default sqlhosts file for running demos.
#
#**************************************************************************
# IANA () assigned port number/service names for Informix:
# sqlexec 9088/tcp
# sqlexec-ssl 9089/tcp

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
mydbsn onipcshm localhost mydbsn
~

"sqlhosts" 21L, 657C written
[informix@localhost etc]$ vi onconfig.mydbsn

###################################################################
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# Copyright IBM Corporation 1996, 2009. All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
# Important: $INFORMIXDIR now resolves to the environment
# variable INFORMIXDIR. Replace the value of the INFORMIXDIR
# environment variable only if the path you want is not under
# $INFORMIXDIR.
#
# For additional information on the parameters:
#
###################################################################

###################################################################
# Root Dbspace Configuration Parameters
###################################################################
# ROOTNAME - The root dbspace name to contain reserved pages and
# internal tracking tables.
# ROOTPATH - The path for the device containing the root dbspace
# ROOTOFFSET - The offset, in KB, of the root dbspace into the
# device. The offset is required for some raw devices.
# ROOTSIZE - The size of the root dbspace, in KB. The value of
# 200000 allows for a default user space of about
# 100 MB and the default system space requirements.
# MIRROR - Enable (1) or disable (0) mirroring
# MIRRORPATH - The path for the device containing the mirrored
# root dbspace
# MIRROROFFSET - The offset, in KB, into the mirrored device
#
# Warning: Always verify ROOTPATH before performing
# disk initialization (oninit -i or -iy) to
# avoid disk corruption of another instance
###################################################################

ROOTNAME rootdbs
ROOTPATH /opt/informix/chunks/rootchk
ROOTOFFSET 0
ROOTSIZE 200000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0

###################################################################
# Physical Log Configuration Parameters
###################################################################
# PHYSFILE - The size, in KB, of the physical log on disk.
# If RTO_SERVER_RESTART is enabled, the
# suggested formula for the size of PHSYFILE
# (up to about 1 GB) is:
/TAPEDEV
TAPEDEV /dev/tapedev
LTAPEDEV /dev/tapedev
# BLOCKTIMEOUT - Specifies the amount of time, in seconds,
# for a system block.
###################################################################

CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600

###################################################################
# Transaction-Related Configuration Parameters
###################################################################
# TXTIMEOUT - The distributed transaction timeout, in seconds
# DEADLOCK_TIMEOUT - The maximum time, in seconds, to wait for a
# lock in a distributed transaction.
# HETERO_COMMIT - Enables (1) or disables (0) heterogeneous
# commits for a distributed transaction
# involving an EGM gateway.
###################################################################

TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0

###################################################################
# ontape Tape Device Configuration Parameters
###################################################################
# TAPEDEV - The tape device path for backups. To use standard
# I/O instead of a device, set to stdio.
# TAPEBLK - The tape block size, in KB, for backups
# TAPESIZE - The maximum amount of data to put on one backup
# tape. Acceptable values are 0 (unlimited) or any
# positive integral multiple of TAPEBLK.
###################################################################

TAPEDEV /dev/null
TAPEBLK 32
TAPESIZE 0

###################################################################
# ontape Logial Log Tape Device Configuration Parameters
###################################################################
# LTAPEDEV - The tape device path for logical logs
# LTAPEBLK - The tape block size, in KB, for backing up logical
# logs
# LTAPESIZE - The maximum amount of data to put on one logical
# log tape. Acceptable values are 0 (unlimited) or any
# positive integral multiple of LTAPEBLK.
###################################################################

LTAPEDEV /dev/null LTAPEBLK 32
LTAPESIZE 0

###################################################################
# Backup and Restore Configuration Parameters
/DBSERVERNAME
CDR_QDATA_SBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_SUPPRESS_ATSRISWARN

SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2

###################################################################
# System Configuration Parameters
###################################################################
# SERVERNUM - The unique ID for the IDS instance. Acceptable
# values are 0 through 255, inclusive.
# DBSERVERNAME - The name of the default database server
# DBSERVERALIASES - The list of up to 32 alternative dbservernames,
# separated by commas
###################################################################

SERVERNUM 0
DBSERVERNAME mydbsn
DBSERVERALIASES

"onconfig.mydbsn" 1121L, 52717C written
[informix@localhost etc]$ cd .. [informix@localhost ~]$ mkdir /opt/informix/chunks
[informix@localhost ~]$ cd /opt/informix/chunks [informix@localhost chunks]$ touch rootchk
[informix@localhost chunks]$ chmod 660 *
[informix@localhost chunks]$ whoami informix
[informix@localhost chunks]$ oninit -ivy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/opt/informix/etc/onconfig.mydbsn'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/opt/informix/etc/.infos.mydbsn"...succeeded
Linking conf file "/opt/informix/etc/.conf.mydbsn"...succeeded
Checking config parameters...succeeded
Writing to infos file...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 10572 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
[informix@localhost etc]$ dbaccessdemo7

DBACCESS Demonstration Database Installation Script

Dropping existing stores_demo database ....

Creating stores_demo database ....

Lockmode set.

Database created.

Database closed.

Database selected.

Lockmode set.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Index created.

Table created.

Database closed.

Loading data ...

Database selected.

Lockmode set.

28 row(s) loaded.

23 row(s) loaded.

9 row(s) loaded.

74 row(s) loaded.

67 row(s) loaded.

52 row(s) loaded.

5 row(s) loaded.

7 row(s) loaded.

Statistics updated.

Permission granted.

Database closed.

Database selected.

Lockmode set.

74 row(s) loaded.

Database closed.

Database selected.

Routine executed.

Table created.

1 row(s) inserted.

Table created.

1 row(s) inserted.

1 row(s) inserted.

1 row(s) inserted.

1 row(s) inserted.

Table created.

1 row(s) inserted.

1 row(s) inserted.

1 row(s) inserted.

1 row(s) inserted.

Row type created.

Table created.

1 row(s) inserted.

Statistics updated.

Permission granted.

Database closed.

The creation of the demonstration database is now complete. The remainder
of this script copies the examples into your current directory.
Press "Y" to continue, or "N" to abort.
y

Now copying SQL command files ....

End of DBACCESSDEMO script.

[informix@localhost etc]$ dbaccess stores_demo

Database selected.
DBACCESS: Query-language Connection Database Table Session Exit
Exit DBACCESS.

----------------------- ----- Press CTRL-W for Help --------

Database closed.

[informix@localhost etc]$
-------------------------------------------------

說明：

一、mydbsn:為dbservername，其實隨便起一個名就可以了。只要保證這個名字和檔案onconfig.XXX的XXX、環境變數ONCONFIG的值、環境變數INFORMIXSERVER、$INFORMIXDIR/etc/sqlhosts中的dbservername的值以及onconfig.XXX中的DBSERVERNAME的值一致就可以了。

二、關於$INFORMIXDIR/etc/sqlhosts的配置：
其實我也不大明白，但http://www.qqread.com/informix/v902209705.html 寫的比較詳細。

三、dbaccessdemo7 是安裝演示資料庫的意思

只要按照上面的去做一般不會有問題。如果在oninit -ivy 時報如下錯誤：

oninit: Fatal error in shared memory initialization

基本上因為
mkdir /opt/informix/chunks
cd /opt/informix/chunks
touch rootchk
chmod 660 *

與onconfig.mydbsn中的 ROOTPATH /opt/informix/chunks/rootchk 不一致造成。

四、如果報錯資訊為：

Initializing rhead structure...succeeded
Initialization of Encryption...succeeded
The specified service name or protocol is unknown. Error -25507.
Initializing ASF...FAILED

則要考慮onconfig.XXX檔案中的“NETTYPE”的配置是否和sqlhosts一致。比如onconfig檔案中配置成“NETTYPE ipcshm,1,50,CPU”，則sqlhosts也得配置成“onipcshm”，否則將會出現如上錯誤。再比如，如果sqlhost配置成：
mydbsn onsoctcp 100.100.100.80 8001
則onconfig.XXX檔案中的“NETTYPE”配置成：
NETTYPE soctcp,1,50,CPU

注意：一個是onsoctcp,一個是soctcp