Sinodb 12.1安装与优化

系统要求

Informix Server System Requirements (ibm.com)

环境准备

Linux版本：SUSE Linux Enterprise Server 12 SP4"

Linux主机名：linuxdb

informix安装包：iif.12.10.FC7U0X4.linux-x86_64.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

使用参数生效

​/sbin/sysctl -p​

环境准备

disable_selinux

SUSEfirewall2

"select * from blocks where id='20240710105909-bxvbexp'"

create DB folder

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

create datafile folders

cd /opt/sinodb
touch rootchk plogchk llogchk tempchk01 sbspace01  datachk01
chown informix:informix *
chmod 660 *

[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

cd /software
tar -xvf /software/iif.12.10.FC7U0X4.linux-x86_64.tar

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




===============================================================================
Host Name
---------

Enter the host name for your machine.

Host Name: (Default: infsrv):




===============================================================================
Specify Apache Port Number
--------------------------

Please specify the port number for the Apache webserver.

Specify the port number for the Apache web server.

Port Number (Default: 8080):




===============================================================================
Security Features
-----------------

With OAT password protection, only OAT administrators can add  and  edit
connection groups and change OAT configurations. Other users can   manage
Sinoregal database servers, but they cannot modify connection groups and OAT
configurations.

Enable OAT Password Protection? (Default: yes):



=============================================================