Informix install in linux as4 u5

<b></b>

<b>Informix11.5 linux as4 u5</b><b>安裝</b>

一、軟體包下載下傳

在IBM網站上注冊并下載下傳安裝包：

iif.11.50.UC3DE.Linux-RHEL4.tar for   iif.11.50.UC3DE.Linux-RHEL4  xmanager3.0

二、安裝

1.         安裝系統包openmotif-2.2.3-6.RHEL4.2.i386.rpm

對于 IDS 圖形工具，從 CD #3 安裝 OpenMotif 運作庫。 将 CD #3 放入驅動器。它會自動安裝。 要安裝軟體包，請在終端中鍵入以下指令：

 rpm -Uvh /media/cdrom/RedHat/RPMS/openmotif-2.2.3-6.RHEL4.2.i386.rpm

2.         建立informix使用者群組

[root@mail RPMS]# groupadd informix

[root@mail RPMS]# useradd -g informix -m informix

[root@mail RPMS]# passwd informix

Changing password for user informix.

New UNIX password:

BAD PASSWORD: it is based . a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@mail RPMS]# id informix

uid=1002(informix) gid=1003(informix) groups=1003(informix)

[root@mail RPMS]#  mkdir /opt/informix

[root@mail RPMS]# chown informix:informix /opt/Informix

3.         解壓軟體

軟體被放在/home/soft/目錄下進入/opt/informix目錄執行以下指令

[root@mail informix]# tar xvf /home/soft/iif.11.50.UC3DE.Linux-RHEL4.tar

4.         設定INFORMIXDIR和DISPLAY變量

export INFORMIXDIR=/opt/informix

[root@mail informix]# export DISPLAY=192.168.1.155:0.0

Windows用戶端IP 192.168.1.155，使用xmanager軟體把安裝界面拉到用戶端

5.         安裝軟體過程

1)        進入軟體目錄執行安裝程式ids_install

[root@mail opt]# cd /opt/Informix

[root@mail informix]# ls

bundle.ini  DBLD      ids_install          images  README.html  suite.jar

CSDK        ICONNECT  ids_install.command  JDBC    SERVER

 [root@mail informix]# ./ids_install

            Do you want to run installer in GUI mode [y/n] :

y

           Entering GUI Mode.

          Initializing InstallShield Wizard........

          Launching InstallShield Wizard........

Dec 22, 2008 11:35:43 AM java.util.prefs.FileSystemPreferences$2 run

INFO: Created user preferences directory.

Dec 22, 2008 11:35:43 AM java.util.prefs.FileSystemPreferences$3 run

INFO: Created system preferences directory in java.home.

2)        單擊next 

3)        單擊next

4)        選擇I accept both the IBM and the non-IBM terms

5)        選擇目錄位置/opt/Informix（預設），單擊next

不選擇IConnect Version3.50，因為安裝Client-SDK時IConnect Version3.50就會被自動安裝

6)        單擊next

是否啟用角色分離，預設為no，單擊next

7)        是否建立demonstration資料庫伺服器執行個體，預設為no，單擊next

8)        總結界面，

9)        單擊next

對話框内容如下：

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 .config 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

        Set ROOTPATH

        Set ROOTSIZE   

Initialize database server

        As informix or root, run .init

        If initializing a new server for the FIRST time, run .init -i

                This will overwrite any existing data, so use caution . an existing setup

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

10)     單擊next

11)     單擊finish

以上均為root使用者登陸，操作

三、配置 IDS（以下使用informix使用者登陸）

1.         設定環境

以 informix 使用者身份登入，則将使用者 ID 切換為 informix：

[root@mail informix]# su - informix

2.         編輯環境檔案ids.env

建立一個名為 ids.env 的環境檔案，例如： gedit ids.env

[informix@mail ~]$ vi ids.env

将以下指令行（總計3行）添加到 ids.env 檔案：

export INFORMIXSERVER=demo_on

export PATH=$INFORMIXDIR/bin:$PATH

儲存檔案并退出編輯器。

3.         使 IDS 設定環境生效：

[informix@mail ~]$ . ./ids.env （使環境變量生效）

（鍵入： 點 空格 點 斜杠 ids.env）

每次需要通路該 IDS 執行個體時，您可以再次從此檔案設定環境。

4.         建立和編輯 IDS 配置檔案：

cd $INFORMIXDIR/etc

cp .config.std .config

cp sqlhosts.std sqlhosts

記錄檔：

[informix@mail ~]$ cd $INFORMIXDIR/etc

[informix@mail etc]$ pwd

/opt/informix/etc

[informix@mail etc]$ ls

ac_config.std    buildsmi          glsfiles                  odbcinst.ini

alarmprogram.sh  CLI-cr            Glsfiles                  onconfig.std

ASF-cr           ClientSDK-cr      Glsfiles.installed        OSLIB-cr

blduser.sh       clientsdkfiles    ibmifmx_security.sh       plconfig.std

bldutil.sh       clone             IDS1150.SYS2              release_notes.png

boot1000a.sql    cmsm.cfg.sample   ids_16.png                setup.odbc

boot1000.sql     cnv10to1110.sql   ifx_failover_callback.sh  smi_6to7

boot1110.sql     cnv50t60.sql      IIF-cr                    smi_load

boot1150.sql     cnv50t92.sql      IIFfiles                  smi_unld

boot901.sql      cnv94t100.sql     IIFfiles.installed        sm_versions.std

boot90.sql       conv              IM_ic_16.png              sqlhosts

boot910b.sql     CPLUS-cr          IM_uninstall_16.png       sqlhosts.cmsm.sample

boot910.sql      cvtlongid7x.sql   informixdir-is-insecure   sqlhosts.std

boot911.sql      cvtlongid914.sql  install                   SQLI-cr

boot911u.sql     cvtviotab         installc                  sysadmin

boot912b.sql     DMI-cr            log_full.sh               syscdcv1.sql

boot912.sql      do_role_sep       make-informixdir-secure   syscdr.sql

boot920a.sql     dropcdr.sql       manifest.inf              syscdrview.sql

boot920b.sql     dummyupds         messagefiles              sysmaster.sql

boot920c.sql     dummyupds100.sql  Messagefiles              sysuser.sql

boot920.sql      ESQL-cr           Messagefiles.installed    sysutils.sql

boot930a.sql     evidence.sh       MSG-cr                    termcap

boot940.sql      GENLIB-cr         no_log.sh                 typetab

brand            GLS-cr            odbc.ini                  xpg4_is.sql

[informix@mail etc]$ cp .config.std .config

[informix@mail etc]$ cp sqlhosts.std sqlhosts

5.         編輯檔案 .config，更改參數：

1)        實際配置

ROOTPATH     /home/informix/dbspaces/online_root

MSGPATH      /home/informix/logs/online.log

LTAPEDEV        /dev/tapedev 改為 /dev/null

DBSERVERNAME    預設為 空 改為demo_on

2)        找到機器網絡節點的主機名：

[informix@mail etc]$ uname -n

mail

3)        用選擇的編輯器（如上所示）編輯檔案 sqlhosts，更改指令行：

[informix@mail etc]$ vi sqlhosts

demo_on .ipcshm   on_hostname改為mail（linux主機名）    on_servername 改為demo_on（資料庫伺服器名）

修改後内容：

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

#

#  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

demo_on .ipcshm        mail    demo_on

demo_se seipcpip        se_hostname     sqlexec

6.         建立日志目錄和資料空間目錄

[informix@mail etc]$ mkdir /home/informix/logs

[informix@mail etc]$ mkdir /home/informix/dbspaces

[informix@mail etc]$ cd /home/informix/dbspaces/

[informix@mail dbspaces]$ touch .line_root

[informix@mail dbspaces]$ ls

online_root

[informix@mail dbspaces]$ chmod 660 .line_root

7.         啟動和關閉

1)        啟動并初始化配置的 IDS 執行個體

 [informix@mail etc]$ .init -iv

This action will initialize IBM Informix Dynamic Server;

any existing IBM Informix Dynamic Server databases will NOT be accessible -

Do you wish to continue (y/n)? y

2)        輸入y

Checking group membership to determine server run mode...succeeded

Reading configuration file '/opt/informix/etc/onconfig'...succeeded

Creating /INFORMIXTMP/.infxdirs...succeeded

Creating infos file "/opt/informix/etc/.infos.demo_on"...succeeded

Linking conf file "/opt/informix/etc/.conf.demo_on"...succeeded

Checking config parameters...succeeded

Writing to infos file...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 10570 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 .mode_mon thread...succeeded

Creating periodic thread...succeeded

Starting scheduling system...succeeded

Verbose output complete: mode = 5

 [informix@mail dbspaces]$ cd ..

[informix@mail ~]$ .init -iv

[informix@mail ~]$

四、相關指令

1.         初始化環境變量

用infomix使用者登陸

2.         啟動informix

[informix@mail ~]$ .init

3.關閉執行個體

onmode  -ky

五、測試

1.         運作測試程式dbaccessdemo7

[informix@mail ~]$ dbaccessdemo7

DBACCESS  Demonstration Database Installation .

Dropping existing stores_demo database ....

Creating stores_demo database ....

Lockmode set.

Database created.

Database closed.

Database selected.

Table created.

Index created.

Loading data ...

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.

Routine executed.

1 row(s) inserted.

Row type created.

The creation of the demonstration database is now complete.  The remainder

of this . copies the examples into your current directory.

Press "Y" to continue, or "N" to abort.

2.         輸入y

Now copying SQL command files ....

End of DBACCESSDEMO ..

3.         進入控制程式dbaccess

[informix@mail ~]$ dbaccess

菜單欄為：

Query-language  Connection  Database  Table  Session  Exit

DBACCESS:   Query-language  Connection  Database  Table  Session  Exit

Use SQL query language.

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

<a href="http://down.51cto.com/data/2351457" target="_blank">附件：http://down.51cto.com/data/2351457</a>

本文轉自 pgmia 51CTO部落格，原文連結:http://blog.51cto.com/heyiyi/121815