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

​
===============================================================================
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 . . . 证明创建成功