informix部署安装

informix部署安装

一、环境准备

Linux版本：centos7.6

Linux主机名：localhost

informix安装包：ibm.ids.14.10.FC4W1.LNX.tar

informix服务名：tramsserver

二、安装步骤

• 整个安装过程都以root用户运行

1、创建informix用户

[root@localhost ~]# groupadd -g 1000 informix
[root@localhost ~]# useradd -g informix -d /opt/informix -m -s /bin/bash informix
[root@localhost ~]# passwd informix

2、设置环境变量

[root@localhost ~]# vim /etc/profile
export INFORMIXDIR=/opt/informix
export PATH=$PATH:$INFORMIXDIR/bin
[root@localhost ~]# source ~/.bash_profile

3、下载安装包，并解压到指定目录

[root@localhost ~]# wget https://iwm.dhe.ibm.com/sdfdl/2v2/regs2/mstadm/informix/Xa.2/Xb.b8S61sgM5_wbIY2eu1IgSWOXUiAHscn1_QsVHmtqepM/Xc.ibm.ids.14.10.FC4W1.LNX.tar/Xd./Xf.lPr.D1vt/Xg.11014678/Xi.ifxids/XY.regsrvs/XZ._vpR5KvQSI-1gTctlOzatPtZJDFbtkHt/ibm.ids.14.10.FC4W1.LNX.tar
[root@localhost ~]# tar -xf ibm.ids.14.10.FC4W1.LNX.tar -C /opt/informix/

4、执行 ids_install 进行安装

• 选择非GUI模式安装，其他根据提示保持默认选项，也就是回车

[root@localhost ~]# cd /opt/informix/
[root@localhost informix]# ./ids_install
Preparing to install
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
​
Launching installer...
​
===============================================================================
                                                (created with InstallAnywhere)
-------------------------------------------------------------------------------
​
Preparing CONSOLE Mode Installation...
​
​
​
​
===============================================================================
Getting Started
---------------
​
This application will guide you through the installation of IBM Informix
Software Bundle Developer edition.
​
Copyright HCL Technologies Ltd. 2017, 2020. All rights reserved.
Copyright IBM Corporation 2001, 2017. All rights reserved.
​
1. Release Notes
The Release Notes can be found in
/opt/informix/doc/ids_unix_relnotes_14.10.html
​
2. Launch Online Documentation:
Access the IBM Informix 14.10 Knowledge Center at
https://www.ibm.com/support/knowledgecenter/SSGU8G/welcomeIfxServers.html
​
To Begin Installation,
Respond to each prompt to proceed to the next step in the installation.
If you want to change something on a previous step, type 'back'.
​
You may cancel this installation at any time by typing 'quit'.
​
PRESS <ENTER> TO CONTINUE:
​
​
​
===============================================================================
​
​
​
​
  无保证程序的国际许可协议
​
  第一部分 - 通用条款
​
  下载、安装、复制、访问、单击“接受”按钮，或以其他方式使用程序，即表明
  被许可方同意本协议的条款。如果您代表被许可方接受此类条款，则您陈述并保
  证您拥有完全的授权以使该被许可方接受此类条款的约束。如果您不同意此类条
  款，
​
  * 则请勿下载、安装、复制、访问、单击“接受”按钮，或使用程序；并且
​
  * 立即将未使用的介质和文档退还至提供方，以便获得您所支付金额的退款。如
  果下载了程序，那么请销毁程序的所有副本。
​
   1. 定义
​
  “授权使用” - 被许可方被授权执行或运行程序的指定级别。该级别可按用户
  数、百万个服务单位（MSUs）、处理器价值单元（PVUs）或其他 IBM 指定的使用
  级别进行计量。
​
​
按 Enter 键继续查看本许可协议或按 "1" 接受本协议，按 "2" 拒绝本协议，按 "3" 打印本协议，按 "5" 用英语查看，或按 "99"
  回到上一屏幕。: 1
​
​
​
​
===============================================================================
Installation Location
---------------------
​
Choose location for software installation
​
Default Install Folder: /opt/informix
​
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
    :
​
​
​
===============================================================================
Installation or Distribution
----------------------------
​
Select the installation type.
​
Typical: Install the database server with all features and a database server
that
is configured with default values. Includes:
** Client Software Development Kit (CSDK)
​
​
Custom: Install the database server with specific features and software that
you need.
Optionally install a configured database server instance.
Minimum disk space required: 75 MB (without a server instance)
​
 ->1- Typical installation
   2- Custom installation
   3- Extract the product files (-DLEGACY option)
​
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
​
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
Server Instance
---------------
​
Type 'back' to go to the previous step or 'quit' to cancel the installation.
​
Create a database server instance?
​
​
​
 ->1- Yes - create a server instance
   2- No - do not create a server instance
​
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
​
​
​
​
===============================================================================
Configuration - Number of Users
-------------------------------
​
Select the number of expected database users.
​
 ->1- 1 - 100
   2- 101 - 500
   3- 501 - 1000
   4- 1000+
​
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
​
​
​
​
===============================================================================
Installation Summary
--------------------
​
Please review the following before continuing:
​
Product Name:
  IBM Informix Software Bundle
​
Install Folder:
  /opt/informix
​
Product Features:
  IBM Informix database server,
  Base Server,
  Extensions and tools,
  J/Foundation,
  Database extensions,
  Conversion and reversion support,
  XML publishing,
  Demonstration database scripts,
  Enterprise Replication,
  Data loading utilities,
  onunload and onload utilities,
  dbload utility,
  High-Performance Loader,
  Backup and Restore,
  archecker utility,
  ON-Bar utility,
  Interface to Tivoli Storage Manager,
  Administrative utilities,
  Performance monitoring utilities,
  Miscellaneous monitoring utilities,
  Auditing utilities,
  Database import and export utilities,
  JSON Client Support,
  Global Language Support (GLS),
  West European and Americas,
  East European and Slavic,
  Japanese,
  Korean,
  Chinese,
  Thai
​
Disk Space Information (for Installation Target):
  Required:     678,199,718 Bytes
  Available: 42,623,873,024 Bytes
​
PRESS <ENTER> TO CONTINUE:
​
​
​
===============================================================================
Ready To Install
----------------
​
InstallAnywhere is now ready to install IBM Informix Software Bundle onto your
system at the following location:
​
  /opt/informix
​
PRESS <ENTER> TO INSTALL:
​
​
​
===============================================================================
Installing...
-------------
​
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
Creating links, branding....
-
​
===============================================================================
​
​
Please Wait
-----------
​
Changing owners....
-
​
===============================================================================
​
​
Please Wait
-----------
​
Changing directory ownership
-
​
===============================================================================
​
​
Please Wait
-----------
​
Installing IBM GSKit.....
-
​
===============================================================================
​
​
Please Wait
-----------
​
Executing Installation Script...
-
​
===============================================================================
Server Initialization
---------------------
​
The server will now be initialized. Initialization might take quite a while,
depending on the performance of your computer.
​
PRESS <ENTER> TO CONTINUE:
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
Initializing IDS ....
\
​
===============================================================================
Using the new instance
----------------------
​
A database server instance was created. If you chose to initialize the
instance, it is ready to use.
​
You can open a command prompt to an initialized instance by running one of the
following commands at /opt/informix, where ol_informix1410 is the path or
filename of the instance.
​
Windows:
ol_informix1410.cmd
​
UNIX csh:
source ol_informix1410.csh
​
UNIX ksh or bourne:
./ol_informix1410.ksh
​
If initialization fails, check the online.log file for messages. The
instance's root chunk must be owned by the correct user and group, and it must
have readable and writable (rw) permission bits set only for owner and group.
​
PRESS <ENTER> TO CONTINUE:
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
​
​
===============================================================================
​
​
Please Wait
-----------
​
Creating links, branding....
-
​
===============================================================================
Installation Complete
---------------------
​
Congratulations! IBM Informix Software Bundle installation is complete.
​
Product install status:
Informix Dynamic Server: Successful
​
​
For more information about using Informix products, see the IBM Informix 14.10
Knowledge Center at
https://www.ibm.com/support/knowledgecenter/SSGU8G/welcomeIfxServers.html.
​
PRESS <ENTER> TO EXIT THE INSTALLER:
​

三、安装后的配置

1、修改"~/.basr_profile"文件，加入如下环境变量

[root@localhost informix]# vim ~/.bash_profile
export INFORMIXDIR=/opt/informix
export INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts
export ONCONFIG=onconfig.tramsserver
export INFORMIXSERVER=tramsserver
export PATH=$INFORMIXDIR/bin:.:$PATH
​
[root@localhost informix]# source ~/.bash_profile

2、拷贝"onconfig"配置模板

[root@localhost informix]# cd $INFORMIXDIR/etc
[root@localhost etc]# cp onconfig.std onconfig.tramsserver

3、编辑 onconfig.tramsserver ，修改或添加以下内容

• 修改或添加以下内容

[root@localhost etc]# vim onconfig.tramsserver
ROOTNAME rootdbs
ROOTPATH /opt/informix/data/rootdbs
LTAPEDEV /dev/null
​

修改结果如下

[root@localhost etc]# grep -Ev '^$|^#' onconfig.tramsserver
ROOTNAME rootdbs
ROOTPATH /opt/informix/data/rootdbs
ROOTOFFSET 0
ROOTSIZE 300000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0
PHYSFILE 50000
PLOG_OVERFLOW_PATH  $INFORMIXDIR/tmp
PHYSBUFF 128
LOGFILES 6
LOGSIZE 10000
DYNAMIC_LOGS 2
LOGBUFF 64
LTXHWM 70
LTXEHWM 80
MSGPATH $INFORMIXDIR/tmp/online.log
MSG_DATE 0
CONSOLE $INFORMIXDIR/tmp/online.con
TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1
DBSPACETEMP
SBSPACETEMP
SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2
SERVERNUM 49
DBSERVERNAME tramsserver
DBSERVERALIASES
FULL_DISK_INIT  0
NETTYPE ipcshm,1,50,CPU
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
NUMFDSERVERS 4
NS_CACHE host=900,service=900,user=900,group=900,sqlhosts=900
NET_IO_TIMEOUT_ALARM 0
DRDA_COMMBUFFSIZE 32
MULTIPROCESSOR 0
VPCLASS cpu,num=1,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0
AUTO_TUNE 1
CLEANERS 8
DIRECT_IO 0
LOCKS 20000
DEF_TABLE_LOCKMODE page
RESIDENT 0
SHMBASE 0x44000000L
SHMVIRTSIZE 32656
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS
CKPTINTVL 300
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600
CONVERSION_GUARD 2
RESTORE_POINT_DIR $INFORMIXDIR/tmp
TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0
TAPEDEV /dev/tapedev
TAPEBLK 32
TAPESIZE 0
LTAPEDEV /dev/null
LTAPEBLK 32
LTAPESIZE 0
BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_MAX_RESTORE
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
BAR_CKPTSEC_TIMEOUT 15
BAR_HISTORY 0
PSM_DBS_POOL   DBSPOOL
PSM_LOG_POOL   LOGPOOL
DD_HASHSIZE 31
DD_HASHMAX  10
DS_HASHSIZE 31
DS_POOLSIZE 127
PC_HASHSIZE 31
PC_POOLSIZE 127
PRELOAD_DLL_FILE
STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
STMT_CACHE_QUERY_PLAN 0
USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0
USELASTCOMMITTED "NONE"
FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
ONLIDX_MAXMEM 5120
MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 256
DATASKIP
OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
IFX_FOLDVIEW 1
STATCHANGE 10
USTLOW_SAMPLE 1
BATCHEDREAD_TABLE   1
BATCHEDREAD_INDEX   1
EXPLAIN_STAT 1
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL
TLS_VERSION
PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31
SQL_LOGICAL_CHAR OFF
SEQ_CACHE_SIZE 10
ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 131072
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_SUPPRESS_ATSRISWARN
CDR_DELAY_PURGE_DTC     0
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0
CDR_MAX_DYNAMIC_LOGS 0
GRIDCOPY_DIR    $INFORMIXDIR
CDR_TSINSTANCEID 0
CDR_MAX_FLUSH_SIZE 50
CDR_AUTO_DISCOVER 0
CDR_MEM 0
SHARD_MEM 0
SHARD_ID  0
SHARD_EDGE_NODE  0
DRAUTO                  0
DRINTERVAL              0
HDR_TXN_SCOPE           NEAR_SYNC
DRTIMEOUT               30
HA_ALIAS
HA_FOC_ORDER           SDS,HDR,RSS
DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO               0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT             20
SDS_TEMPDBS
SDS_PAGING
SDS_LOGCHECK            10
SDS_ALTERNATE           NONE
SDS_FLOW_CONTROL        0
UPDATABLE_SECONDARY     0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT     0
TEMPTAB_NOLOG           0
DELAY_APPLY             0
STOP_APPLY              0
LOG_STAGING_DIR
RSS_FLOW_CONTROL        0
SMX_NUMPIPES            1
ENABLE_SNAPSHOT_COPY    0
SMX_COMPRESS            0
SMX_PING_INTERVAL       10
SMX_PING_RETRY          6
CLUSTER_TXN_SCOPE       SERVER
RSS_NONBLOCKING_CKPT    0
SEC_LOGREC_MAXBUFS      1000
SEC_DR_BUFS             12
SEC_APPLY_POLLTIME      0
ON_RECVRY_THREADS  1
OFF_RECVRY_THREADS 10
DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh
RAS_PLOG_SPEED  25000
RAS_LLOG_SPEED 0
EILSEQ_COMPAT_MODE  0
QSTATS 0
WSTATS 0
USERMAPPING OFF
SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30
AUTOLOCATE 0
DEFAULTESCCHAR \
MQSERVER
MQCHLLIB
MQCHLTAB
REMOTE_SERVER_CFG
REMOTE_USERS_CFG
S6_USE_REMOTE_SERVER_CFG  0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
GSKIT_VERSION
INFORMIXCONTIME 60
INFORMIXCONRETRY 1
JVPPROPFILE   $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar
BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50
BUFFERPOOL size=2k,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60
​

4、创建"rootdbs"数据库空间文件

[root@localhost ~]# cd /opt/informix/
[root@localhost ~]# mkdir data
[root@localhost ~]# cd data
[root@localhost ~]# touch rootdbs logdbs tempdbs userdbs phydbs
[root@localhost ~]# chmod 660 *dbs

注意：“rootdbs”文件权限必须是：660

5、修改"/opt/informix/etc/sqlhosts"文件

[root@localhost ~]# cd $INFORMIXDIR/etc
[root@localhost etc]# cp sqlhosts.std sqlhosts
[root@localhost etc]# vim sqlhosts
tramsserver onsoctcp 192.168.30.34 8888

第一列位数据库服务名

第三列为主机IP

第四列为informix服务的端口

四、重新初始化数据库

1、先关闭数据库

[root@localhost etc]# onmode -ky

2、初始化数据库

[root@localhost etc]# onmode -ky

• 查看消息日志

[root@localhost etc]# onstat -m

• 开启当前数据库进程

[root@localhost etc]# oninit -vy

3、进入数据库，创建一个数据库

[root@localhost etc]# dbaccess

按照以下操作进行

Database -- Create -- 《输入数据库的名称》 回车 -- Exit -- Create-new-database

出现Running . . . 证明创建成功