Install DB2 9.7 in CentOS7

scp ./v9.7fp7_linuxx64_server.tar.gz [email protected]:/tmp/

# 創建需要的目錄
mkdir -p /db2
mkdir /source

# 複製安裝包到映像內
mv /tmp/v9.7fp7_linuxx64_server.tar.gz /source

# 安裝必要的依賴包
yum update -y
yum install -y gcc libaio libstdc++ libstdc++-devel pam perl tar pam.i686 libnsl libnsl.i686 glibc.i686
# OL9
yum install -y glibc.i686 libstdc++.i686
yum install -y https://rpmfind.net/linux/mageia/distrib/cauldron/x86_64/media/core/release/libstdc++5-3.3.6-19.mga9.x86_64.rpm
# OL9 離線安裝準備 rpm
yumdowner gcc glibc libaio libnsl libnsl libstdc++ libstdc++-devel libstdc++-devel pam perl glibc glibc-common glibc-gconv-extra glibc-langpack-en libgcc libgomp libstdc++ pam annobin audit-libs cpp dwz efi-srpm-macros fonts-srpm-macros gcc-c++ gcc-plugin-annobin ghc-srpm-macros glibc-devel glibc-gconv-extra glibc-headers go-srpm-macros kernel-headers kernel-srpm-macros libcap-ng libdatrie libdb libeconf libgcc libmpc libpkgconf libselinux libsepol libthai libxcrypt libxcrypt-devel llvm-libs lua-srpm-macros ocaml-srpm-macros openblas-srpm-macros openssl-libs pcre2 perl-Algorithm-Diff perl-Archive-Tar perl-Archive-Zip perl-Attribute-Handlers perl-AutoLoader perl-AutoSplit perl-B perl-Benchmark perl-CPAN perl-CPAN-Meta perl-CPAN-Meta-Requirements perl-CPAN-Meta-YAML perl-Carp perl-Class-Struct perl-Compress-Bzip2 perl-Compress-Raw-Bzip2 perl-Compress-Raw-Lzma perl-Compress-Raw-Zlib perl-Config-Extensions perl-Config-Perl-V perl-DBM_Filter perl-DB_File perl-Data-Dumper perl-Data-OptList perl-Data-Section perl-Devel-PPPort perl-Devel-Peek perl-Devel-SelfStubber perl-Devel-Size perl-Digest perl-Digest-MD5 perl-Digest-SHA perl-Digest-SHA1 perl-DirHandle perl-Dumpvalue perl-DynaLoader perl-Encode perl-Encode-devel perl-English perl-Env perl-Errno perl-Exporter perl-ExtUtils-CBuilder perl-ExtUtils-Command perl-ExtUtils-Constant perl-ExtUtils-Embed perl-ExtUtils-Install perl-ExtUtils-MM-Utils perl-ExtUtils-MakeMaker perl-ExtUtils-Manifest perl-ExtUtils-Miniperl perl-ExtUtils-ParseXS perl-Fcntl perl-File-Basename perl-File-Compare perl-File-Copy perl-File-DosGlob perl-File-Fetch perl-File-Find perl-File-HomeDir perl-File-Path perl-File-Temp perl-File-Which perl-File-stat perl-FileCache perl-FileHandle perl-Filter perl-Filter-Simple perl-FindBin perl-GDBM_File perl-Getopt-Long perl-Getopt-Std perl-HTTP-Tiny perl-Hash-Util perl-Hash-Util-FieldHash perl-I18N-Collate perl-I18N-LangTags perl-I18N-Langinfo perl-IO perl-IO-Compress perl-IO-Compress-Lzma perl-IO-Socket-IP perl-IO-Socket-SSL perl-IO-Zlib perl-IPC-Cmd perl-IPC-Open3 perl-IPC-SysV perl-IPC-System-Simple perl-Importer perl-JSON-PP perl-Locale-Maketext perl-Locale-Maketext-Simple perl-MIME-Base64 perl-MIME-Charset perl-MRO-Compat perl-Math-BigInt perl-Math-BigInt-FastCalc perl-Math-BigRat perl-Math-Complex perl-Memoize perl-Module-Build perl-Module-CoreList perl-Module-CoreList-tools perl-Module-Load perl-Module-Load-Conditional perl-Module-Loaded perl-Module-Metadata perl-Module-Signature perl-Mozilla-CA perl-NDBM_File perl-NEXT perl-Net perl-Net-Ping perl-Net-SSLeay perl-ODBM_File perl-Object-HashBase perl-Opcode perl-POSIX perl-Package-Generator perl-Params-Check perl-Params-Util perl-PathTools perl-Perl-OSType perl-PerlIO-via-QuotedPrint perl-Pod-Checker perl-Pod-Escapes perl-Pod-Functions perl-Pod-Html perl-Pod-Perldoc perl-Pod-Simple perl-Pod-Usage perl-Safe perl-Scalar-List-Utils perl-Search-Dict perl-SelectSaver perl-SelfLoader perl-Socket perl-Software-License perl-Storable perl-Sub-Exporter perl-Sub-Install perl-Symbol perl-Sys-Hostname perl-Sys-Syslog perl-Term-ANSIColor perl-Term-Cap perl-Term-Complete perl-Term-ReadLine perl-Term-Size-Perl perl-Term-Table perl-Test perl-Test-Harness perl-Test-Simple perl-Text-Abbrev perl-Text-Balanced perl-Text-Diff perl-Text-Glob perl-Text-ParseWords perl-Text-Tabs+Wrap perl-Text-Template perl-Thread perl-Thread-Queue perl-Thread-Semaphore perl-Tie perl-Tie-File perl-Tie-Memoize perl-Tie-RefHash perl-Time perl-Time-HiRes perl-Time-Local perl-Time-Piece perl-URI perl-Unicode-Collate perl-Unicode-Normalize perl-Unicode-UCD perl-User-pwent perl-autodie perl-autouse perl-base perl-bignum perl-blib perl-constant perl-debugger perl-deprecate perl-devel perl-diagnostics perl-doc perl-encoding perl-encoding-warnings perl-experimental perl-fields perl-filetest perl-if perl-inc-latest perl-interpreter perl-less perl-lib perl-libnet perl-libnetcfg perl-libs perl-local-lib perl-locale perl-macros perl-meta-notation perl-mro perl-open perl-overload perl-overloading perl-parent perl-perlfaq perl-ph perl-podlators perl-sigtrap perl-sort perl-srpm-macros perl-subs perl-threads perl-threads-shared perl-utils perl-vars perl-version perl-vmsish pkgconf pkgconf-m4 pkgconf-pkg-config pyproject-srpm-macros python-srpm-macros qt5-srpm-macros redhat-rpm-config rust-srpm-macros sombok systemtap-sdt-devel zip zlib perl-CPAN-DistnameInfo perl-Encode-Locale perl-Term-Size-Any perl-TermReadKey perl-Unicode-LineBreak

yum clean all

## 變更核心參數
echo "fs.file-max = 16384" >> /etc/sysctl.conf
### 關閉Linux地址空間隨機, 解決 DBT3534W
echo "kernel.randomize_va_space = 0"  >> /etc/sysctl.conf

sysctl -p /etc/sysctl.d/gcb.conf /etc/sysctl.conf

# 解壓安裝包並安裝 DB2
cd /source
tar -xzf v9.7fp7_linuxx64_server.tar.gz

vi /source/server/db2_install.rsp

## 建議可以在這邊做快照


groupadd -g 700 db2iadm1 &&\
groupadd -g 701 db2fadm1 &&\
groupadd -g 702 dasadm1 &&\
useradd -u 700 -g db2iadm1 -m -d /home/db2inst1 db2inst1 &&\
useradd -u 701 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1 &&\
useradd -u 702 -g dasadm1 -m -d /home/dasusr1 dasusr1 &&\
cd /source/server
./db2prereqcheck &&\
./db2setup -r /source/server/db2_install.rsp
# /opt/IBM/db2/V9.7/instance/db2icrt -u db2fenc1 db2inst1

chown db2inst1: /db2

echo "export DB2DIR=/opt/ibm/db2/V9.7" >> /home/db2inst1/.bashrc
echo "export PATH=\$DB2DIR/bin:\$PATH" >> /home/db2inst1/.bashrc
echo "export LD_LIBRARY_PATH=\$DB2DIR/lib:\$LD_LIBRARY_PATH" >> /home/db2inst1/.bashrc

Post Install Recommendations 
-----------------------------

Required steps: 
You can connect to the DB2 instance "db2inst1" using the port number "50000". Record it for future reference. 

In order to start using DB2 you need to logon using a valid user ID such as the DB2 instance owner's ID "db2inst1". 

Optional steps: 
Some features, such as OS-based authentication, DB2 High Availability, and configuring the DB2 Advanced Copy Services (ACS) directory are available only in root installations. Also, reserving service names for TCP/IP remote connection or DB2 Text Search is available only in root installations. To enable these features and abilities in non-root installations, run the db2rfe script as the root user with a configuration file. See /opt/ibm/db2/V9.7/instance/db2rfe.cfg for an example of the configuration file. 

To start using the DB2 instance "root", you must set up the DB2 instance environment by sourcing db2profile (for Bourne or Korn shell) or db2cshrc (for C shell) in the sqllib directory with the command ".  $HOME/sqllib/db2profile" or "source   $HOME/sqllib/db2cshrc". $HOME represents the home directory of the DB2 instance. You can also open a new login window of the DB2 instance user. 

To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V9.7/bin/db2val. For more information, see "db2val" in the DB2 Information Center. 

Refer to "What's new" http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0052035.html in the DB2 Information Center to learn about the new functions for DB2 V9.7. 

Open First Steps by running "db2fs" using a valid user ID such as the DB2 instance owner's ID. You will need to have DISPLAY set and a supported web browser in the path of this user ID. 

Verify that you have access to the DB2 Information Center based on the choices you made during this installation. If you performed a typical or a compact installation, verify that you can access the IBM Web site using the internet. If you performed a custom installation, verify that you can access the DB2 Information Center location specified during the installation. 

You should ensure that you have the correct license entitlements for DB2 products and features installed on this machine. Each DB2 product or feature comes with a license certificate file (also referred to as a license key) that is distributed on an Activation CD, which also includes instructions for applying the license file. If you purchased a base DB2 product, as well as, separately priced features, you might need to install more than one license certificate. The Activation CD for your product or feature can be downloaded from Passport Advantage if it is not part of the physical media pack you received from IBM. For more information on licensing, search the Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp) using terms such as "licensing" or "db2licm". 


DB2 Setup log file finished at:  Mon 01 Jul 2024 02:56:44 PM CST CST
============================================================

# 匯入授權
db2licm -a db2/license/db2aese_c.lic
# 檢視授權資訊
db2licm -l

mkdir -p /db2/data/swjdb

su - db2inst1

db2start

db2 create db swjdb on /db2/data/swjdb/

db2 connect to swjdb

db2 update dbm cfg using DFTDBPATH /db2/data/swjdb/

db2 disconnect current

sudo vi /usr/local/bin/cunstom_startup_script.sh
sudo vi /etc/systemd/system/cunstom_startup.service
sudo chmod +x /usr/local/bin/cunstom_startup_script.sh
sudo systemctl start cunstom_startup_script.service
sudo systemctl enable cunstom_startup.service

#!/bin/bash

su - db2inst1 -c db2start

[Unit]
Description=My Startup Service
After=network.target

[Service]
Type=oneshot
ExecStart=/usr/local/bin/cunstom_startup_script.sh
RemainAfterExit=true

[Install]
WantedBy=multi-user.target

sudo systemctl enable cunstom_shutdown.service

#!/bin/bash

su - db2inst1 -c db2stop

[Unit]
Description=My Shutdown Service
DefaultDependencies=no
Before=shutdown.target reboot.target halt.target

[Service]
Type=oneshot
ExecStart=/usr/local/bin/cunstom_shutdown_script.sh
RemainAfterExit=true

[Install]
WantedBy=halt.target reboot.target shutdown.target

firewall-cmd --permanent --add-port=50000/tcp