informix 14 LVM模式安装

系统要求

Informix Server System Requirements (ibm.com)

RHEL 7

• Minimum update 4
• Base kernel version 3.10.0
• Glibc version 2.17
• Compiler 4.8.5
  Standard C++ library, libstdc++.so.6 must be installed

环境准备

Linux版本：CentOS Linux release 7.9.2009 (Core)

Linux主机名：infsrv

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

informix服务名：infor

内核参数调整

cat >> /etc/sysctl.conf << EOF
kernel.shmmax = 4398046511104
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 100 32000 1024 2048
vm.swappiness = 0
EOF

cat >> /etc/security/limits.conf <<EOF
* soft nproc 40960
* hard nproc 81920
root soft nproc unlimited
* soft nofile 102400
* hard nofile 204800
root soft nofile unlimited
EOF

环境准备

setenforce 0sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config

disable_FW

create informix user & group

groupadd -g 1000 informix
useradd -g informix -d /home/informix -m -s /bin/bash  informix
passwd informix

su - informix
cat >> ~/.bash_profile << EOF
export INFORMIXDIR=/opt/informix
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts
export ONCONFIG=onconfig.infor
export INFORMIXSERVER=infor
export PATH=$INFORMIXDIR/bin:$PATH
EOF

注：INFERMIXSERVER = instance name (sqlhost) = DBSERVERNAME (onconfig)

create DB folder

mkdir -p /data/informix
chmod 755 /data
chmod 755 /data/informix
chown informix:informix /data/informix

以 root 身份登录，创建"rootdbs"数据库空间文件：

rootdbs必须660

create datafile folders

pvcreate /dev/sdb
vgcreate vgdata /dev/sdb
lvcreate -n lvrootchk -L 1050M vgdata
lvcreate -n lvplogchk -L 1050M vgdata
lvcreate -n lvllogchk -L 1050M vgdata
lvcreate -n lvtempchk01 -L 1050M vgdata
lvcreate -n lvsbspace01 -L 1050M vgdata
lvcreate -n lvdatachk01 -L 1050M vgdata

cd /dev/vgdata
chown informix:informix lv*
chmod 0660 lv*
ll ../dm-[3-8]

mkdir -p /data/informix
chmod 775 /data
chmod 775 /data/informix
chown informix:informix /data/informix
cd /data/informix
ln -s /dev/vgdata/lvrootchk rootchk
ln -s /dev/vgdata/lvplogchk plogchk
ln -s /dev/vgdata/lvllogchk llogchk
ln -s /dev/vgdata/lvtempchk01 tempchk01
ln -s /dev/vgdata/lvsbspace01 sbspace01
ln -s /dev/vgdata/lvdatachk01 datachk01

[root@infsrv informix]# pvcreate /dev/sdb
  Physical volume "/dev/sdb" successfully created.
[root@infsrv informix]# vgcreate vgdata /dev/sdb
  Volume group "vgdata" successfully created
[root@infsrv informix]# lvcreate -n lvrootchk -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvrootchk" created.
[root@infsrv informix]# lvcreate -n lvplogchk -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvplogchk" created.
[root@infsrv informix]# lvcreate -n lvllogchk -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvllogchk" created.
[root@infsrv informix]# lvcreate -n lvtempchk01 -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvtempchk01" created.
[root@infsrv informix]# lvcreate -n lvsbspace01 -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvsbspace01" created.
[root@infsrv informix]# lvcreate -n lvdatachk01 -L 1050M vgdata
  Rounding up size to full physical extent <1.03 GiB
  Logical volume "lvdatachk01" created.
[root@infsrv vgdata]# ll
total 0
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvdatachk01 -> ../dm-8
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvllogchk -> ../dm-5
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvplogchk -> ../dm-4
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvrootchk -> ../dm-3
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvsbspace01 -> ../dm-7
lrwxrwxrwx. 1 root root 7 Jul 10 11:31 lvtempchk01 -> ../dm-6

[root@infsrv vgdata]# chown informix:informix lv*
[root@infsrv vgdata]# chmod 0660 lv*
[root@infsrv vgdata]# ll ../dm-[3-8]
brw-rw----. 1 informix informix 253, 3 Jul 10 15:16 ../dm-3
brw-rw----. 1 informix informix 253, 4 Jul 10 11:31 ../dm-4
brw-rw----. 1 informix informix 253, 5 Jul 10 11:31 ../dm-5
brw-rw----. 1 informix informix 253, 6 Jul 10 11:31 ../dm-6
brw-rw----. 1 informix informix 253, 7 Jul 10 11:31 ../dm-7
brw-rw----. 1 informix informix 253, 8 Jul 10 11:31 ../dm-8

Install informix DB (root account)

cd /software
tar -xvf /software/ibm.ids.14.10.FC10W1.LNX.tar
tar -xvf /software/ibm.ids.14.10.FC10W1.LNX.tar -C /opt/informix/

#选择非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, 2023. 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:

Press Enter to continue viewing the license agreement, or enter "1" to
   accept the agreement, "2" to decline it, "3" to print it, or "99" to go back
   to the previous screen.: 1

===============================================================================
Installation Location
---------------------

Choose location for software installation

  Default Install Folder: /opt/IBM/Informix_Software_Bundle

ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
      : /opt/informix

INSTALL FOLDER IS: /opt/informix
   IS THIS CORRECT? (Y/N): y

===============================================================================
Installation or Distribution
----------------------------

Select the i