DB2 11.5.7.0 Installation Guide on Linux

Update : Below steps are valid for DB2 11.7 installation on Linux as well.

Step1 : Check below link for most up to date installation requirement.

System requirements for IBM Db2 for Linux, UNIX, and Windows

Step2 : Download DB2 LUW product image from below link

https://epwt-www.mybluemix.net/software/support/trial/cst/programwebsite.wss?siteId=1120&tabId=2932&p=null&h=null

 Step 3: Copy DB2 LUW product to your target server

Step 4: Extract DB2 product 

[root@MaxwellDBA home]# cd DB2
[root@MaxwellDBA DB2]# ls -ltr
total 1826100
-rw-r--r-- 1 root root 1869925829 Sep  8 03:02 v11.5.7_linuxx64_server_dec.tar.gz
[root@MaxwellDBA DB2]# 

 

tar -zxvf <DB2 product image file name>

[root@MaxwellDBA DB2]# tar -zxvf v11.5.7_linuxx64_server_dec.tar.gz

Post extract completion you will find new directory server/server_t/server_dec got created.

[root@MaxwellDBA DB2]# ls -ltr
total 1826100
drwxr-xr-x 3 root root        206 Nov 23  2021 server_dec
-rw-r--r-- 1 root root 1869925829 Sep  8 03:02 v11.5.7_linuxx64_server_dec.tar.gz

Change current working directory to server_dec

[root@MaxwellDBA DB2]# cd server_dec/
[root@MaxwellDBA server_dec]# ls -ltr
total 84
-r-xr-xr-x 1 bin bin  5059 Nov 23  2021 db2setup
-r-xr-xr-x 1 bin bin  5059 Nov 23  2021 db2prereqcheck
-r-xr-xr-x 1 bin bin  5041 Nov 23  2021 db2ls
-r-xr-xr-x 1 bin bin  5207 Nov 23  2021 db2_deinstall
-r--r--r-- 1 bin bin 16809 Nov 23  2021 db2checkCOL.tar.gz
-r--r--r-- 1 bin bin  4987 Nov 23  2021 db2checkCOL_readme.txt
-r-xr-xr-x 1 bin bin  5077 Nov 23  2021 db2_install
-r-xr-xr-x 1 bin bin  5254 Nov 23  2021 db2ckupgrade
-r-xr-xr-x 1 bin bin  5095 Nov 23  2021 installFixPack
drwxr-xr-x 6 bin bin   134 Nov 23  2021 db2
[root@MaxwellDBA server_dec]# 

Step 5: Perform prerequisite check'

 ./db2prereqcheck -i -v 11.5.7.0

-i : Check prerequisite for non pureScale installation

-v : Check prerequisite for specific DB2 version

[root@MaxwellDBA server_dec]# ./db2prereqcheck -i -v 11.5.7.0

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

Thu Sep  8 04:10:38 2022
Checking prerequisites for DB2 installation. Version "11.5.7.0". Operating system "Linux" 
   
Validating "Linux distribution " ... 
   Required minimum operating system distribution: "CENTOS"; Version: "6"; Service pack: "7". 
   Actual operating system distribution Version: "8"; Service pack: "5". 
   Requirement matched. 
   
Validating "ksh symbolic link" ... 
   Requirement matched. 
   
Validating "kernel level " ... 
   Required minimum operating system kernel level: "3.10.0". 
   Actual operating system kernel level: "4.18.0". 
   Requirement matched. 
   
Validating "ipcmni_extend kernel parameter " ... 
   WARNING : Requirement not matched. 
   
Validating "C++ Library version " ... 
   Required minimum C++ library: "libstdc++.so.6" 
   Standard C++ library is located in the following directory: "/usr/lib64/libstdc++.so.6.0.25". 
   Actual C++ library: "CXXABI_1.3.1" 
   Requirement matched. 
   

Validating "32 bit version of "libstdc++.so.6" " ... 
   Found the 64 bit "/lib64/libstdc++.so.6" in the following directory "/lib64". 
DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6". 
   
Validating "libaio.so version " ... 
DBT3553I  The db2prereqcheck utility successfully loaded the libaio.so.1 file. 
   Requirement matched. 
   
Validating "libnuma.so version " ... 
DBT3610I  The db2prereqcheck utility successfully loaded the libnuma.so.1 file. 
   Requirement matched. 
   
Validating "/lib/libpam.so*" ... 
   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". 
   WARNING : Requirement not matched. 
Requirement not matched for DB2 database "Server" . Version: "11.5.7.0". 
Summary of prerequisites that are not met on the current system: 
   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". 


DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6". 


[root@MaxwellDBA server_dec]# 

If your prerequisite check fails, fix it before proceeding with DB2 installation. 

IBM Documentation

The errors are not critical and can be ignored.

Step 6: Installation

DB2 Installation Methods :

• DB2 Setup Wizard: You can install DB2 using GUI, for this you need to have access to X Window System (X11)
• Response file installation: In this method you can perform DB2 installation silently with preconfigured option, best suited for automating DB2 installation.
• db2_install command: Interactive CLI based installation. 
• PayLoad deployment: It is advance installation method which is not recommended for most users. In this method post installation, you need to manual configured DB2 installation.

It is recommended to perform DB2 installation with root privilege for enterprise setup. DB2 can be installed with normal user as well.

This post will cover DB2 installation using root user with db2_install command method.

Start DB2 installation by executing below command

• SERVER : Install DB2 server product
• CONSV : Install DB2 Connect
• CLIENT : Install DB2 client
• RTCL : Install DB2 runtime client

./db2_install

[root@MaxwellDBA server_dec]# ./db2_install
Requirement not matched for DB2 database "Server" . Version: "11.5.7.0". 

Summary of prerequisites that are not met on the current system: 

   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". 


DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6". 


Read the license agreement file in the db2/license directory.

***********************************************************
To accept those terms, enter "yes". Otherwise, enter "no" to cancel the install process. [yes/no]
yes
 
 
Default directory for installation of products - /opt/ibm/db2/V11.5

***********************************************************
Install into default directory (/opt/ibm/db2/V11.5) ? [yes/no] 
yes
 
 
Specify one of the following keywords to install DB2 products.

  SERVER 
  CONSV 
  CLIENT 
  RTCL 
 
Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
SERVER
***********************************************************
Do you want to install the DB2 pureScale Feature? [yes/no] 
no
Requirement not matched for DB2 database "Server" . Version: "11.5.7.0". 

Summary of prerequisites that are not met on the current system: 

   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*". 


DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6". 


DB2 installation is being initialized.

 Total number of tasks to be performed: 55 
Total estimated time for all tasks to be performed: 2332 second(s) 

Task #1 start
Description: Checking license agreement acceptance 
Estimated time 1 second(s) 
Task #1 end 

Task #2 start
Description: Base Client Support for installation with root privileges 
Estimated time 3 second(s) 
Task #2 end 

Task #3 start
Description: Product Messages - English 
Estimated time 14 second(s) 
Task #3 end 

Task #4 start
Description: Base client support 
Estimated time 360 second(s) 
Task #4 end 

Task #5 start
Description: Java Runtime Support 
Estimated time 215 second(s) 
Task #5 end 

Task #6 start
Description: Java Help (HTML) - English 
Estimated time 7 second(s) 
Task #6 end 

This will start your DB2 installation. DB2 installation should complete within 5 to 10 mins. If your system meet DB2 installation requirement and prerequisite check was successful then DB2 installation will complete successfully. At the end of installation you will get installation log file name which you can be referred for detailed DB2 installation logs.

Task #55 start
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #55 end 

The execution completed with warnings.

For more information see the DB2 installation log at
"/tmp/db2_install.log.408514".
[root@MaxwellDBA server_dec]# 

Step 7: Verify installation

Change your working directory to DB2 installation path and run ls -lrt 

You should see below directories and all directories must be own by bin.

[root@MaxwellDBA V11.5]# cd /opt/ibm/db2/V11.5
[root@MaxwellDBA V11.5]# ls -ltr
total 76
drwxr-xr-x  2 bin  bin     23 Nov 23  2021 acs
drwxr-xr-x  3 bin  bin    294 Nov 23  2021 java
drwxr-xr-x  5 bin  bin   4096 Nov 23  2021 include
drwxr-xr-x  4 bin  bin     27 Nov 23  2021 conv
drwxr-xr-x  2 bin  bin    234 Nov 23  2021 Readme
drwxr-xr-x  5 bin  bin     57 Nov 23  2021 json
lrwxrwxrwx  1 root root    12 Nov 23  2021 logs -> install/logs
drwxr-xr-x  2 bin  bin     63 Nov 23  2021 map
drwxr-xr-x  3 bin  bin     17 Nov 23  2021 R
drwxr-xr-x  3 bin  bin    116 Nov 23  2021 security64
drwxr-xr-x  3 bin  bin     20 Nov 23  2021 security32
drwxr-xr-x  3 bin  bin     37 Nov 23  2021 python
drwxr-xr-x  6 bin  bin     55 Nov 23  2021 ha
drwxr-xr-x  2 bin  bin     76 Nov 23  2021 adsm
drwxr-xr-x  2 bin  bin    225 Nov 23  2021 pd
drwxr-xr-x  2 bin  bin   4096 Nov 23  2021 misc
drwxr-xr-x 31 bin  bin   4096 Nov 23  2021 samples
drwxr-xr-x  2 bin  bin    148 Nov 23  2021 dasfcn
drwxr-xr-x  7 bin  bin    124 Nov 23  2021 das
drwxr-xr-x  6 bin  bin     64 Nov 23  2021 federation
drwxr-xr-x  2 bin  bin   8192 Nov 23  2021 bnd
drwxr-xr-x  4 bin  bin   4096 Nov 23  2021 tools
drwxr-xr-x  5 bin  bin     80 Nov 23  2021 desktop
drwxr-xr-x  3 bin  bin   8192 Nov 23  2021 bin
drwxr-xr-x  3 bin  bin     62 Nov 23  2021 gskit
drwxr-xr-x  2 bin  bin    312 Nov 23  2021 guardium
drwxr-xr-x  2 bin  bin     26 Nov 23  2021 gse
drwxr-xr-x  3 bin  bin    112 Nov 23  2021 function
drwxr-xr-x  3 bin  bin     21 Nov 23  2021 properties
drwxr-xr-x  4 bin  bin   4096 Nov 23  2021 instance
drwxr-xr-x  3 bin  bin     20 Nov 23  2021 doc
drwxr-xr-x  3 bin  bin     28 Nov 23  2021 msg
drwxr-xr-x  7 bin  bin     70 Nov 23  2021 db2tss
drwxr-xr-x  2 bin  bin   4096 Nov 23  2021 adm
drwxr-xr-x  4 bin  bin     57 Nov 23  2021 infopop
drwxr-xr-x  3 bin  bin   4096 Sep  8 04:32 lib32
drwxr-xr-x  4 bin  bin  12288 Sep  8 04:32 lib64
drwxr-xr-x  4 bin  bin   4096 Sep  8 04:33 cfg
drwxr-xr-x 41 bin  bin   4096 Sep  8 04:33 license
drwxr-xr-x  5 bin  bin    156 Sep  8 04:33 install
[root@MaxwellDBA V11.5]# 

db2ls output should list your installation entry.

[root@MaxwellDBA V11.5]# cd /opt/ibm/db2/V11.5
[root@MaxwellDBA V11.5]# ls -ltr
total 76
drwxr-xr-x  2 bin  bin     23 Nov 23  2021 acs
drwxr-xr-x  3 bin  bin    294 Nov 23  2021 java
drwxr-xr-x  5 bin  bin   4096 Nov 23  2021 include
drwxr-xr-x  4 bin  bin     27 Nov 23  2021 conv
drwxr-xr-x  2 bin  bin    234 Nov 23  2021 Readme
drwxr-xr-x  5 bin  bin     57 Nov 23  2021 json
lrwxrwxrwx  1 root root    12 Nov 23  2021 logs -> install/logs
drwxr-xr-x  2 bin  bin     63 Nov 23  2021 map
drwxr-xr-x  3 bin  bin     17 Nov 23  2021 R
drwxr-xr-x  3 bin  bin    116 Nov 23  2021 security64
drwxr-xr-x  3 bin  bin     20 Nov 23  2021 security32
drwxr-xr-x  3 bin  bin     37 Nov 23  2021 python
drwxr-xr-x  6 bin  bin     55 Nov 23  2021 ha
drwxr-xr-x  2 bin  bin     76 Nov 23  2021 adsm
drwxr-xr-x  2 bin  bin    225 Nov 23  2021 pd
drwxr-xr-x  2 bin  bin   4096 Nov 23  2021 misc
drwxr-xr-x 31 bin  bin   4096 Nov 23  2021 samples
drwxr-xr-x  2 bin  bin    148 Nov 23  2021 dasfcn
drwxr-xr-x  7 bin  bin    124 Nov 23  2021 das
drwxr-xr-x  6 bin  bin     64 Nov 23  2021 federation
drwxr-xr-x  2 bin  bin   8192 Nov 23  2021 bnd
drwxr-xr-x  4 bin  bin   4096 Nov 23  2021 tools
drwxr-xr-x  5 bin  bin     80 Nov 23  2021 desktop
drwxr-xr-x  3 bin  bin   8192 Nov 23  2021 bin
drwxr-xr-x  3 bin  bin     62 Nov 23  2021 gskit
drwxr-xr-x  2 bin  bin    312 Nov 23  2021 guardium
drwxr-xr-x  2 bin  bin     26 Nov 23  2021 gse
drwxr-xr-x  3 bin  bin    112 Nov 23  2021 function
drwxr-xr-x  3 bin  bin     21 Nov 23  2021 properties
drwxr-xr-x  4 bin  bin   4096 Nov 23  2021 instance
drwxr-xr-x  3 bin  bin     20 Nov 23  2021 doc
drwxr-xr-x  3 bin  bin     28 Nov 23  2021 msg
drwxr-xr-x  7 bin  bin     70 Nov 23  2021 db2tss
drwxr-xr-x  2 bin  bin   4096 Nov 23  2021 adm
drwxr-xr-x  4 bin  bin     57 Nov 23  2021 infopop
drwxr-xr-x  3 bin  bin   4096 Sep  8 04:32 lib32
drwxr-xr-x  4 bin  bin  12288 Sep  8 04:32 lib64
drwxr-xr-x  4 bin  bin   4096 Sep  8 04:33 cfg
drwxr-xr-x 41 bin  bin   4096 Sep  8 04:33 license
drwxr-xr-x  5 bin  bin    156 Sep  8 04:33 install
[root@MaxwellDBA V11.5]# cd install
[root@MaxwellDBA install]# ls -ltr
total 152
-r-xr-xr-x 1 bin  bin   9607 Nov 23  2021 db2un.rsp
-r-xr-xr-x 1 bin  bin  13082 Nov 23  2021 db2ls
-r-xr--r-- 1 bin  bin  18411 Nov 23  2021 db2_deinstall_exec
-r-xr--r-- 1 bin  bin  40524 Nov 23  2021 db2_deinstall
-r-xr-xr-x 1 bin  bin  20225 Nov 23  2021 db2chgpath
drwxr-xr-x 2 bin  bin     38 Nov 23  2021 tsamp
drwxr-xr-x 2 bin  bin     40 Nov 23  2021 pcmk
-r-xr-xr-x 1 bin  bin  44624 Sep  8 04:32 db2ls_exec
drwxr-xr-x 2 root root    54 Sep  8 04:33 logs
[root@MaxwellDBA install]# db2ls

Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID 
---------------------------------------------------------------------------------------------------------------------
/opt/ibm/db2/V11.5               11.5.7.0        0                            Thu Sep  8 04:33:52 2022 CST             0 
[root@MaxwellDBA install]# 

Step 8: Create DB2 instance and apply license.

How to create DB2 Instance on Linux