informix安装

家电修理 2023-07-16 19:17www.caominkang.com电器维修

###
### https://baijiahao.baidu./s?id=1658662120415101350&fr=spider&for=pc
### https://copyfuture./blogs-details/20210102122709849l
### https://.bbsmax./A/KE5Qran0dL/
### https://blog.csdn./hjn0618/article/details/101798918

###
###

# https://.ibm./support/pages/docker-informix%E5%AE%9E%E8%B7%B5
docker run -dit --name informix --privileged -p 19088:9088 -p 19089:9089 -h informix
-p 27017:27017 -p 27018:27018 -p 27883:27883 -e LICENSE=aept
-v /data/ibm/informix:/opt/ibm/data
ibm/informix-developer-database

docker run -itd --name mydb2 --privileged=true -p 50000:50000 -h db2node
-e LICENSE=aept -e DB2INST1_PASSWORD=12345678 -e DBNAME=testdb -v /data/ibm/db2:/database ibm/db2

##################################################################################
################ 安装informix ################
##################################################################################

docker run -dit --privileged --name informix -h informix centos:8.4.2105 init
get https://mirrors.aliyun./repo/Centos-vault-8.5.2111.repo

docker cp ibm.ids.14.10.FC2.LNX.tar informix:/
docker cp Centos-vault-8.5.2111.repo informix:/

docker exec -it informix bash

cd /etc/yum.repos.d
mkdir bak
mv .repo bak
mv /Centos-vault-8.5.2111.repo /etc/yum.repos.d
yum clean all
yum install -y tel libaio -tools

yum hatprovides libm.so.6
yum hatprovides libncurses.so.5
yum hatprovides libc.so.6

yum install -y glibc-2.28-164.el8.i686
yum install -y ncurses-pat-libs-6.1-9.20180224.el8.i686
yum install -y glibc-2.28-164.el8.i686

groupadd -g 1000 informix
useradd -u 1000 -g 1000 -m -s /bin/bash informix
echo "informix:123456" | chpassd

mkdir -p /opt/ibm/informix
chon -R informix:informix /opt/ibm

cat >> /home/informix/.bash_profile <

LD_LIBRARY_PATH=/usr/lib64
INFORMIXDIR=/opt/ibm/informix
PATH=$PATH:$INFORMIXDIR/bin
INFORMIXSERVER=mysrv01

export INFORMIXDIR PATH LD_LIBRARY_PATH INFORMIXSERVER
EOF

mkdir /informix
mv /ibm.ids.14.10.FC2.LNX.tar /informix/
cd /informix
tar -xf ibm.ids.14.10.FC2.LNX.tar
cd /usr/lib64/
ln -s libncurses.so.6.1 libncurses.so.5
cd /informix
export LD_LIBRARY_PATH=/usr/lib64
./ids_install

##################################################################
===============================================================================
Prerequisite Verification Check
-------------------------------

One or more prerequisite system libraries are not installed on your puter.
Install libm.so.6, libc.so.6, libncurses.so.5 and then restart the IBM
Informix installation program.

The installation cannot sueed until the minimum requirements are met. For
more information about the prerequisites, see your Installation Guide or check
ith your System Administrator.

PRESS TO ACCEPT THE FOLLOWING (OK):
##################################################################

解决问题
https://.ibm./support/pages/apar/IT32637

Create softlink from libncurses.so.5 to libncurses.so.6.1 (the
supplied lib on RHEL 8).
Also, create softlink for libtinfo (/usr/lib64/libtinfo.so.5 ->
libtinfo.so.6.1) for dbaess to ork.

[root@informix informix]# find / -name 'libncurses.so'
/usr/lib/libncurses.so.5
/usr/lib/libncurses.so.5.9
/usr/lib64/libncurses.so.6.1
/usr/lib64/libncurses.so.6
[root@informix informix]#

cd /usr/lib64/
ln -s libncurses.so.6.1 libncurses.so.5

-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------

### 重新执行
### https://.talkithtrend./Question/280865

export LD_LIBRARY_PATH=/usr/lib64
./ids_install

### 安装路径 /opt/ibm/informix

### 安装过程
### ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[root@informix 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 ith InstallAnyhere)
-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...

===============================================================================
Getting Started
---------------

This application ill guide you through the installation of IBM Informix
Softare Bundle Developer edition.

1. Release Notes
The Release Notes can be found in
/informix/doc/ids_unix_relnotes_14.10.html

2. Launch Online Documentation:
Aess the IBM Informix 14.10 Knoledge Center at
https://.ibm./support/knoledgecenter/SSGU8G/eleIfxServers.html

To Begin Installation,
Respond to each prompt to proceed to the next step in the installation.
If you ant to change something on a previous step, type 'back'.

You may cancel this installation at any time by typing 'quit'.

PRESS TO CONTINUE:

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

International License Agreement for Non-Warranted Programs

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN
"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEE AGREES TO
THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON
BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL
AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO
THESE TERMS,

DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT" BUTTON,
OR USE THE PROGRAM; AND

PROMPTLY RETURN THE UNUSED MEDIA AND DOCUMENTATION TO THE PARTY FROM
WHOM IT WAS OBTAINED FOR A REFUND OF THE AMOUNT PAID. IF THE PROGRAM
WAS DOWNLOADED, DESTROY ALL COPIES OF THE PROGRAM.

1. Definitions

Press Enter to continue vieing the license agreement, or enter "1" to
aept 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 softare installation

Default Install Folder: /opt/IBM/Informix_Softare_Bundle

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

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

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

Select the installation type.

Typical: Install the database server ith all features and a database server
that
is configured ith default values. Includes:
Client Softare Development Kit (CSDK)

Custom: Install the database server ith specific features and softare that
you need.
Optionally install a configured database server instance.
Minimum disk space required: 75 MB (ithout a server instance)

->1- Typical installation
2- Custom installation
3- Extract the product files (-DLEGACY option)

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT: 1

===============================================================================
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 TO ACCEPT THE DEFAULT: 2

===============================================================================
Installation Summary
--------------------

Please revie the folloing before continuing:

Product Name:
IBM Informix Softare Bundle

Install Folder:
/opt/ibm/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: 708,474,063 Bytes
Available: 22,380,560,384 Bytes

PRESS TO CONTINUE:

===============================================================================
Ready To Install
----------------

InstallAnyhere is no ready to install IBM Informix Softare Bundle onto your
system at the folloing location:

/opt/ibm/informix

PRESS TO INSTALL:

===============================================================================
Installing...
-------------

[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]

===============================================================================
Please Wait
-----------

Creating links, branding....

===============================================================================
Please Wait
-----------

Changing oners....

===============================================================================
Please Wait
-----------

Changing directory onership

===============================================================================
Please Wait
-----------

Installing IBM GSKit.....

===============================================================================
Please Wait
-----------

Executing Installation Script...

===============================================================================
Please Wait
-----------

Creating links, branding....

===============================================================================
Installation Complete
---------------------

Congratulations! IBM Informix Softare Bundle installation is plete.

Product install status:
Informix Dynamic Server: Suessful

For more information about using Informix products, see the IBM Informix 14.10
Knoledge Center at
https://.ibm./support/knoledgecenter/SSGU8G/eleIfxServers.html.

PRESS TO EXIT THE INSTALLER:

### ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[root@informix informix]# ls -ltr
total 376
drxrxr-x 2 root root 4096 Jul 30 08:19 license
drxr-xr-x 7 informix informix 4096 Jul 30 08:20 gls
-rxr-xr-x 1 root root 89833 Jul 30 08:20 Global_Language_Support_Install_07_30_2022_08_20_11.log
drxr-xr-x 2 informix informix 4096 Jul 30 08:20 hq
drxr-xr-x 4 informix informix 4096 Jul 30 08:20 SDK
drxrxr-x 2 informix informix 4096 Jul 30 08:20 aaodir
drxrxr-x 2 informix informix 4096 Jul 30 08:20 dbssodir
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 doc
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 release
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 msg
drxr-xr-x 20 informix informix 4096 Jul 30 08:20 extend
drxr-xr-x 6 informix informix 4096 Jul 30 08:20 incl
drxr-xr-x 9 informix informix 4096 Jul 30 08:20 demo
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 lib
drxr-xr-x 4 informix informix 4096 Jul 30 08:20 help
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 snmp
drxrxr-x 4 informix informix 4096 Jul 30 08:20 etc
-rxr-xr-x 1 root root 181051 Jul 30 08:20 IBM_Informix_14.10_Install_07_30_2022_08_20_24.log
drxrxr-x 4 informix informix 4096 Jul 30 08:20 uninstall
drxrxr-x 3 root root 4096 Jul 30 08:20 jvm
drxr-xr-x 5 informix informix 4096 Jul 30 08:20 bin
drxrx--- 2 informix informix 4096 Jul 30 08:20 ssl
drxr-xr-x 3 informix informix 4096 Jul 30 08:20 isa
drxrx--- 2 informix informix 4096 Jul 30 08:20 tmp
drxr-xr-x 2 informix informix 4096 Jul 30 08:20 gskit
-rxr-xr-x 1 root root 13958 Jul 30 08:21 IBM_Informix_Softare_Bundle_Install_07_30_2022_08_19_57.log
[root@informix informix]#

[informix@informix ~]$ dbaess
dbaess: error hile loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

#### https://github./mercialhaskell/stack/issues/1012

ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5

[informix@informix etc]$ dbaess
DBACCESS: Query-language Connection Database Table Session Exit
Use SQL query language.

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

[informix@informix ~]$ onmode -ky
shared memory not initialized for INFORMIXSERVER ''

cd /opt/ibm/informix/etc
cp onconfig.std onconfig
cp sqlhosts.demo sqlhosts

echo "export INFORMIXSQLHOSTS=/opt/ibm/informix/etc/sqlhosts" >> ~/.bash_profile
echo "export INFORMIXSERVER=mysrv01" >> ~/.bash_profile

sed -i 's#ROOTPATH $INFORMIXDIR/tmp/demo_on.rootdbs#ROOTPATH $INFORMIXDIR/data/rootdbs#' $INFORMIXDIR/etc/onconfig
sed -i 's/^DBSERVERNAME./DBSERVERNAME mysrv01/' $INFORMIXDIR/etc/onconfig

mkdir $INFORMIXDIR/data
cd $INFORMIXDIR/data
#touch rootdbs phydbs logdbs userdbs tmpdbs
touch rootdbs
chmod 660 dbs

# Unix 环境默认配置文件: $INFORMIXDIR/etc/sqlhosts，如需要设置其他，可以配置环境变量 INFORMIXSQLHOSTS
#
# https://.ibm./docs/en/informix-servers/12.10?ic=files-sqlhosts-file-sqlhosts-registry-key
# https://.ibm./docs/en/informix-servers/14.10?ic=munication-sqlhosts-information
##
cat >> $INFORMIXDIR/etc/sqlhosts < mysrv01 onsoctcp localhost sqlexec
EOF

## 初始化实例

Reading configuration file '/opt/ibm/informix/etc/onconfig'...sueeded
Creating /INFORMIXTMP/.infxdirs...sueeded
Allocating and attaching to shared memory...sueeded
Creating resident pool 4310 kbytes...sueeded
Creating infos file "/opt/ibm/informix/etc/.infos.mysrv01"...sueeded
Linking conf file "/opt/ibm/informix/etc/.conf.mysrv01"...sueeded
Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...sueeded
Initialization of Encryption...sueeded
Initializing ASF...sueeded
Initializing Dictionary Cache and SPL Routine Cache...sueeded
Initializing encryption-at-rest if necessary...sueeded
Bringing up ADM VP...sueeded
Creating VP classes...sueeded
Forking main_loop thread...sueeded
Initializing DR structures...sueeded
Forking 1 'soctcp' listener threads...sueeded
Starting tracing...sueeded
Initializing 8 flushers...sueeded
Initializing log/checkpoint information...sueeded
Initializing dbspaces...sueeded
Opening primary chunks...sueeded
Validating chunks...sueeded
Creating database partition...sueeded
Initialize Async Log Flusher...sueeded
Starting B-tree Scanner...sueeded
Init ReadAhead Daemon...sueeded
Init DB Util Daemon...sueeded
Initializing DBSPACETEMP list...sueeded
Init Auto Tuning Daemon...sueeded
Checking database partition index...sueeded
Initializing dataskip structure...sueeded
Checking for temporary tables to drop...sueeded
Updating Global Ro Counter...sueeded
Forking onmode_mon thread...sueeded
Creating periodic thread...sueeded
Creating VP cache drain thread...sueeded
Creating limits manager thread...sueeded
Starting scheduling system...sueeded
Verbose output plete: mode = 5
[informix@informix data]$

[informix@informix etc]$ onstat -d

IBM Informix Dynamic Server Version 14.10.FC2DE -- On-Line -- Up 00:01:46 -- 172660 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags oner name
45400028 1 0x1 1 1 2048 N BA informix rootdbs
1 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
45400268 1 1 0 150000 84865 PO-B-- /opt/ibm/informix/data/rootdbs
1 active, 32766 maximum

NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to hich they belong.

Expanded chunk capacity mode: alays

########################################################################################
########################################################################################
创建数据库

[informix@informix data]$ dbaess
DBACCESS: Query-language Connection Database Table Session Exit
Use SQL query language.

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

按左右方向键选中Database，并输入Enter

DBACCESS: Query-language Connection Table Session Exit
Select, Create, Info, Drop or Close a database.

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

按左右方向键选中Create，并输入Enter

DATABASE: Select Info Drop cLose Exit
Create a ne database.

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

输入需要创建的数据库名，这里使用的是sakila，并输入Enter

CREATE DATABASE >>
Enter the name you ant to assign to the ne database, then press Return.

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

按左右方向键选中Log，并输入Enter