Installing IBM Db2 v12.1 on Red Hat Enterprise Linux 9.5 (Plow)
In this article, I'm installing IBM Db2 12.1 on Red Hat Enterprise 9.5.
Db2 Community Edition is refreshed and updated for free at major release milestones, but does not come with enterprise-level support. However, there is a robust online community where you can post questions and learn from peers. Community support is available through the IBM Db2
Db2 Community Edition can be downloaded from the IBM Db2 website
We create an user called db2inst1 and a group called dba as root.
groupadd dba
useradd -d /home/db2inst1 -g dba -s /bin/bash db2inst1
We unzip and extract all Db2 installation files
tar xzf v12.1.1_linuxx64_server_dec.tar.gz
A new folder called server_dec is created
cd server_dec/
redhat@server:/home/redhat/software/server_dec>
$ ls -lrt
total 84
-r-xr-xr-x. 1 redhat redhat 5254 Dec 17 12:15 db2ckupgrade
-r-xr-xr-x. 1 redhat redhat 5041 Dec 17 12:16 db2ls
-r--r--r--. 1 redhat redhat 4987 Dec 17 12:16 db2checkCOL_readme.txt
-r-xr-xr-x. 1 redhat redhat 5207 Dec 17 12:16 db2_deinstall
-r--r--r--. 1 redhat redhat 16925 Dec 17 12:16 db2checkCOL.tar.gz
-r-xr-xr-x. 1 redhat redhat 5095 Dec 17 12:16 installFixPack
-r-xr-xr-x. 1 redhat redhat 5059 Dec 17 12:16 db2setup
-r-xr-xr-x. 1 redhat redhat 5059 Dec 17 12:16 db2prereqcheck
-r-xr-xr-x. 1 redhat redhat 5077 Dec 17 12:16 db2_install
drwxr-xr-x. 6 redhat redhat 134 Dec 17 12:16 db2
If we execute the pre-req script db2prereqcheck, we will see many warnings, therefore, the following will have to be executed in order to install the prerequisites.
./db2prereqcheck -v 12.1.1.0
==========================================================================
Wed Apr 9 13:46:22 2025
Checking prerequisites for DB2 installation. Version "12.1.1.0". Operating system "Linux"
Validating "kernel level " ...
Required minimum operating system kernel level: "5.14.0".
Actual operating system kernel level: "5.14.0".
Requirement matched.
Validating "Linux distribution " ...
Required minimum operating system distribution: "RHEL"; Version: "9"; Service pack: "2".
Actual operating system distribution Version: "9"; Service pack: "5".
Requirement matched.
Validating "ksh symbolic link" ...
ERROR : Requirement not matched.
Validating "Bin user" ...
Requirement matched.
Validating "libxcrypt-compat" ...
Package (or file) found: "libxcrypt-compat"
Requirement matched.
Validating "libcurl.so.4 library" ...
Requirement 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.29".
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 only required to support 32-bit non-sql routines: "libstdc++.so.6" provided by the "libstdc++.i686" package.
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 only required to support 32-bit non-sql routines: "/lib/libpam.so*" provided by the "pam.i686" package.
WARNING : Requirement not matched.
Requirement not matched for DB2 database "Server" . Version: "12.1.1.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 only required to support 32-bit non-sql routines: "/lib/libpam.so*" provided by the "pam.i686" package.
DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file only required to support 32-bit non-sql routines: "libstdc++.so.6" provided by the "libstdc++.i686" package.
DBT3618E The db2prereqcheck utility detected that ksh is not linked to ksh, ksh93 or mksh or lksh. This is required for Db2 High Availability Feature.
==========================================================================
Wed Apr 9 13:46:22 2025
Checking prerequisites for DB2 installation with the DB2 pureScale Feature. Version: "12.1.1.0". Operating system: "Linux".
Validating "kernel level " ...
Required minimum operating system kernel level: "5.14.0".
Actual operating system kernel level: "5.14.0".
Requirement matched.
Validating "Linux distribution " ...
Required minimum operating system distribution: "RHEL"; Version: "9"; Service pack: "2".
Actual operating system distribution Version: "9"; Service pack: "5".
Requirement matched.
Validating "ksh symbolic link" ...
ERROR : Requirement not matched.
Validating "Bin user" ...
Requirement matched.
Validating "libxcrypt-compat" ...
Package (or file) found: "libxcrypt-compat"
Requirement matched.
Validating "SELinux status " ...
SELinux is "enabled ".
DBT3563E The db2prereqcheck utility determined that SELinux is enabled, which is not supported with IBM Storage Scale.
ERROR : Requirement not matched.
Validating "libc.so version " ...
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libc.so.6".
Required minimum glibc library version: "2.4.0"
Actual glibc library version: "2.34.0"
Requirement matched.
Validating "gcc" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "gcc".
ERROR : Requirement not matched.
Validating "binutils" ...
Package (or file) found: "binutils"
Requirement matched.
Validating "cpp" ...
Package (or file) found: "cpp"
Requirement matched.
Validating "gcc-c++" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "gcc-c++".
ERROR : Requirement not matched.
Validating "net-tools" ...
Package (or file) found: "net-tools"
Requirement matched.
Validating "m4" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "m4".
ERROR : Requirement not matched.
Validating "NetworkManager-config-server" ...
Package (or file) found: "NetworkManager-config-server"
Requirement matched.
Validating "kernel-devel" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "kernel-devel".
ERROR : Requirement not matched.
Validating "kernel-headers" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "kernel-headers".
ERROR : Requirement not matched.
Validating "file" ...
Package (or file) found: "file"
Requirement matched.
Validating "perl" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "perl".
ERROR : Requirement not matched.
Validating "libgomp" ...
Package (or file) found: "libgomp"
Requirement matched.
Validating "make" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "make".
ERROR : Requirement not matched.
Validating "libgcc" ...
Package (or file) found: "libgcc"
Requirement matched.
Validating "patch" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "patch".
ERROR : Requirement not matched.
Validating "elfutils-libelf-devel" ...
DBT3507E The db2prereqcheck utility failed to find the following package or file: "elfutils-libelf-devel".
ERROR : Requirement not matched.
Validating "python36 link" ...
Found package "python3" on host "rhthodvdbs".
Requirement matched.
Validating "ksh" ...
Required minimum version for "ksh": "1.0.0~beta.1"
WARNING : Requirement not matched.
Validating "/usr/sbin/chronyd" ...
Required minimum version for "/usr/sbin/chronyd": "2.2.1"
Actual version of package: "4.5"
Requirement matched.
Validating "db2prereqPCMK" ...
DBT3622E The db2prereqcheck utility failed to verify the prerequisites for PCMK. Ensure your machine meets all the PCMK installation prerequisites. For detailed information, please check /tmp/db2prereqPCMK.log.*
ERROR : Requirement not matched.
Validating "free space" ...
The directory "/tmp" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/var" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/usr" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/root" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "sg3_utils" ...
Package (or file) found: "sg3_utils"
Requirement matched.
Validating "sg_persist" ...
Package (or file) found: "/usr/bin/sg_persist"
Requirement matched.
Requirement not matched for DB2 database "Server" with pureScale feature . Version: "12.1.1.0".
Summary of prerequisites that are not met on the current system:
DBT3622E The db2prereqcheck utility failed to verify the prerequisites for PCMK. Ensure your machine meets all the PCMK installation prerequisites. For detailed information, please check /tmp/db2prereqPCMK.log.*
Required minimum version for "ksh": "1.0.0~beta.1"
Actual version is undetermined: "ksh".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "elfutils-libelf-devel".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "patch".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "make".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "perl".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "kernel-headers".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "kernel-devel".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "m4".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "gcc-c++".
DBT3507E The db2prereqcheck utility failed to find the following package or file: "gcc".
DBT3563E The db2prereqcheck utility determined that SELinux is enabled, which is not supported with IBM Storage Scale.
DBT3618E The db2prereqcheck utility detected that ksh is not linked to ksh, ksh93 or mksh or lksh. This is required for Db2 High Availability Feature.
so let's install the required libraries.
yum install gcc gcc-c++ patch make perl m4 kernel-devel kernel-headers ksh libstdc++.i686 python3-dnf-plugin-versionlock pam.i686
Also due to this warning,
DBT3563E The db2prereqcheck utility determined that SELinux is enabled, which is not supported with IBM Storage Scale.
We disable SELINUX (SELINUX=enforcing)
vi /etc/selinux/config
SELINUX=disabled
and reboot the server.
If we run it again
./db2prereqcheck -v 12.1.1.0
==========================================================================
Wed Apr 9 13:51:36 2025
Checking prerequisites for DB2 installation. Version "12.1.1.0". Operating system "Linux"
Validating "kernel level " ...
Required minimum operating system kernel level: "5.14.0".
Actual operating system kernel level: "5.14.0".
Requirement matched.
Validating "Linux distribution " ...
Required minimum operating system distribution: "RHEL"; Version: "9"; Service pack: "2".
Actual operating system distribution Version: "9"; Service pack: "5".
Requirement matched.
Validating "ksh symbolic link" ...
Requirement matched.
Validating "Bin user" ...
Requirement matched.
Validating "libxcrypt-compat" ...
Package (or file) found: "libxcrypt-compat"
Requirement matched.
Validating "libcurl.so.4 library" ...
Requirement 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.29".
Actual C++ library: "CXXABI_1.3.1"
Requirement matched.
Validating "32 bit version of "libstdc++.so.6" " ...
Found the 32 bit "/lib/libstdc++.so.6" in the following directory "/lib".
Requirement matched.
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*" ...
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met.
==========================================================================
Wed Apr 9 13:51:36 2025
Checking prerequisites for DB2 installation with the DB2 pureScale Feature. Version: "12.1.1.0". Operating system: "
Linux".
Validating "kernel level " ...
Required minimum operating system kernel level: "5.14.0".
Actual operating system kernel level: "5.14.0".
Requirement matched.
Validating "Linux distribution " ...
Required minimum operating system distribution: "RHEL"; Version: "9"; Service pack: "2".
Actual operating system distribution Version: "9"; Service pack: "5".
Requirement matched.
Validating "ksh symbolic link" ...
Requirement matched.
Validating "Bin user" ...
Requirement matched.
Validating "libxcrypt-compat" ...
Package (or file) found: "libxcrypt-compat"
Requirement matched.
Validating "SELinux status " ...
SELinux is "disabled ".
Requirement matched.
Validating "libc.so version " ...
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libcrypto.so.3.2.2".
Required minimum glibc library version: "2.4.0"
glibc library is located in the following directory "/usr/lib64/libc.so.6".
Required minimum glibc library version: "2.4.0"
Actual glibc library version: "2.34.0"
Requirement matched.
Validating "gcc" ...
Package (or file) found: "gcc"
Requirement matched.
Validating "binutils" ...
Package (or file) found: "binutils"
Requirement matched.
Validating "cpp" ...
Package (or file) found: "cpp"
Requirement matched.
Validating "gcc-c++" ...
Package (or file) found: "gcc-c++"
Requirement matched.
Validating "net-tools" ...
Package (or file) found: "net-tools"
Requirement matched.
Validating "m4" ...
Package (or file) found: "m4"
Requirement matched.
Validating "NetworkManager-config-server" ...
Package (or file) found: "NetworkManager-config-server"
Requirement matched.
Validating "kernel-devel" ...
Package (or file) found: "kernel-devel"
Package "kernel-devel" level "5.14.0-503.35.1.el9_5.x86_64" match with the system "kernel" level "5.14.0-503.35.1.e
l9_5.x86_64".
Requirement matched.
Validating "kernel-headers" ...
Package (or file) found: "kernel-headers"
Package "kernel-headers" level "5.14.0-503.35.1.el9_5.x86_64" match with the system "kernel" level "5.14.0-503.35.1
.el9_5.x86_64".
Requirement matched.
Validating "file" ...
Package (or file) found: "file"
Requirement matched.
Validating "perl" ...
Package (or file) found: "perl"
Requirement matched.
Validating "libgomp" ...
Package (or file) found: "libgomp"
Requirement matched.
Validating "make" ...
Package (or file) found: "make"
Requirement matched.
Validating "libgcc" ...
Package (or file) found: "libgcc"
Requirement matched.
Validating "patch" ...
Package (or file) found: "patch"
Requirement matched.
Validating "elfutils-libelf-devel" ...
Package (or file) found: "elfutils-libelf-devel"
Requirement matched.
Validating "python36 link" ...
Found package "python3" on host "rhthodvdbs".
Requirement matched.
Validating "ksh" ...
Required minimum version for "ksh": "1.0.0~beta.1"
Actual version of package: "1.0.6"
Requirement matched.
Validating "/usr/sbin/chronyd" ...
Required minimum version for "/usr/sbin/chronyd": "2.2.1"
Actual version of package: "4.5"
Requirement matched.
Validating "db2prereqPCMK" ...
Requirement matched.
Validating "free space" ...
The directory "/tmp" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/var" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/usr" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "free space" ...
The directory "/root" has enough space on host "rhthodvdbs".
Requirement matched.
Validating "sg3_utils" ...
Package (or file) found: "sg3_utils"
Requirement matched.
Validating "sg_persist" ...
Package (or file) found: "/usr/bin/sg_persist"
Requirement matched.
Validating "libcurl.so.4 library" ...
Requirement 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.29".
Actual C++ library: "CXXABI_1.3.1"
Requirement matched.
Validating "32 bit version of "libstdc++.so.6" " ...
Found the 32 bit "/lib/libstdc++.so.6" in the following directory "/lib".
Requirement matched.
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*" ...
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met.
The db2prereqcheck utility has confirmed that all installation prerequisites were met.
So we can start the installation.
[root@redhat server_dec]# ./db2_install
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/V12.1
***********************************************************
Install into default directory (/opt/ibm/db2/V12.1) ? [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
DB2 installation is being initialized.
Total number of tasks to be performed: 56
Total estimated time for all tasks to be performed: 2910 second(s)
Task #1 start
Description: Checking license agreement acceptance
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Product Messages - English
Estimated time 14 second(s)
Task #2 end
Task #3 start
Description: Base Client Support for installation with root privileges
Estimated time 3 second(s)
Task #3 end
Task #4 start
Description: Base client support
Estimated time 312 second(s)
Task #4 end
Task #5 start
Description: Java Runtime Support
Estimated time 191 second(s)
Task #5 end
Task #6 start
Description: Java Help (HTML) - English
Estimated time 7 second(s)
Task #6 end
Task #7 start
Description: Global Secure ToolKit
Estimated time 75 second(s)
Task #7 end
Task #8 start
Description: SQL procedures
Estimated time 3 second(s)
Task #8 end
Task #9 start
Description: Java Common files
Estimated time 18 second(s)
Task #9 end
Task #10 start
Description: Base server support for installation with root privileges
Estimated time 3 second(s)
Task #10 end
Task #11 start
Description: ICU Utilities
Estimated time 43 second(s)
Task #11 end
Task #12 start
Description: Java support
Estimated time 11 second(s)
Task #12 end
Task #13 start
Description: Base server support
Estimated time 729 second(s)
Task #13 end
Task #14 start
Description: Relational wrappers common
Estimated time 3 second(s)
Task #14 end
Task #15 start
Description: DB2 data source support
Estimated time 7 second(s)
Task #15 end
Task #16 start
Description: Control Center Help (HTML) - English
Estimated time 13 second(s)
Task #16 end
Task #17 start
Description: Scientific Data Sources
Estimated time 5 second(s)
Task #17 end
Task #18 start
Description: Sample database source
Estimated time 4 second(s)
Task #18 end
Task #19 start
Description: Replication tools
Estimated time 61 second(s)
Task #19 end
Task #20 start
Description: itlm
Estimated time 3 second(s)
Task #20 end
Task #21 start
Description: Oracle data source support
Estimated time 5 second(s)
Task #21 end
Task #22 start
Description: Teradata data source support
Estimated time 3 second(s)
Task #22 end
Task #23 start
Description: Pacemaker
Estimated time 100 second(s)
Task #23 end
Task #24 start
Description: Spatial Extender server support
Estimated time 20 second(s)
Task #24 end
Task #25 start
Description: DB2 Instance Setup wizard
Estimated time 12 second(s)
Task #25 end
Task #26 start
Description: JDBC data source support
Estimated time 260 second(s)
Task #26 end
Task #27 start
Description: Application data sources
Estimated time 4 second(s)
Task #27 end
Task #28 start
Description: Command Line Processor Plus
Estimated time 9 second(s)
Task #28 end
Task #29 start
Description: SQL Server data source support
Estimated time 4 second(s)
Task #29 end
Task #30 start
Description: Informix data source support
Estimated time 4 second(s)
Task #30 end
Task #31 start
Description: Communication support - TCP/IP
Estimated time 3 second(s)
Task #31 end
Task #32 start
Description: IBM Software Development Kit (SDK) for Java(TM)
Estimated time 448 second(s)
Task #32 end
Task #33 start
Description: DB2 LDAP support
Estimated time 4 second(s)
Task #33 end
Task #34 start
Description: Structured file data sources
Estimated time 5 second(s)
Task #34 end
Task #35 start
Description: ODBC data source support
Estimated time 258 second(s)
Task #35 end
Task #36 start
Description: DB2 Text Search
Estimated time 109 second(s)
Task #36 end
Task #37 start
Description: EnterpriseDB code
Estimated time 3 second(s)
Task #37 end
Task #38 start
Description: Sybase data source support
Estimated time 3 second(s)
Task #38 end
Task #39 start
Description: Connect support
Estimated time 3 second(s)
Task #39 end
Task #40 start
Description: Spatial Extender client
Estimated time 3 second(s)
Task #40 end
Task #41 start
Description: Parallel Extension
Estimated time 3 second(s)
Task #41 end
Task #42 start
Description: Base application development tools
Estimated time 36 second(s)
Task #42 end
Task #43 start
Description: Guardium Installation Manager Client
Estimated time 3 second(s)
Task #43 end
Task #44 start
Description: First Steps
Estimated time 3 second(s)
Task #44 end
Task #45 start
Description: Federated Data Access Support
Estimated time 3 second(s)
Task #45 end
Task #46 start
Description: Product Signature for DB2 Server Edition
Estimated time 8 second(s)
Task #46 end
Task #47 start
Description: Setting DB2 library path
Estimated time 180 second(s)
Task #47 end
Task #48 start
Description: Enabling the watchdog
Estimated time 20 second(s)
Task #48 end
Task #49 start
Description: Installing or updating Db2 resource agent scripts for Pacemaker
Estimated time 20 second(s)
Task #49 end
Task #50 start
Description: Executing control tasks
Estimated time 20 second(s)
Task #50 end
Task #51 start
Description: Updating global registry
Estimated time 20 second(s)
Task #51 end
Task #52 start
Description: Starting DB2 Fault Monitor
Estimated time 10 second(s)
Unit db2fmcd.service could not be found.
Task #52 end
Task #53 start
Description: Updating the db2ls and db2greg link
Estimated time 1 second(s)
Task #53 end
Task #54 start
Description: Registering DB2 licenses
Estimated time 5 second(s)
Task #54 end
Task #55 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #55 end
Task #56 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #56 end
Task #57 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #57 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2_install.log.5985".
And then we can list installed Db2 products using db2ls
cd /opt/ibm/db2/V12.1/install
db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
---------------------------------------------------------------------------------------------------------------------
/opt/ibm/db2/V12.1 12.1.1.0 0 Wed Apr 9 13:54:42 2025 BST 0
And also the license
cd /opt/ibm/db2/V12.1/adm/
db2licm -l
Product name: "DB2 Community Edition"
License type: "Community"
Expiry date: "Permanent"
Product identifier: "db2dec"
Version information: "12.1"
Max amount of memory (GB): "8"
Max number of cores: "4"
Enforcement policy: "Hard Stop"
Features:
IBM DB2 Performance Management Offering: "Not licensed"
And create the Db2 instance: db2inst1
cd /opt/ibm/db2/V12.1/instance
./db2icrt -u db2inst1 db2inst1
DBI1446I The db2icrt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.44593".
DBI1070I Program db2icrt completed successfully.
Then switch user to the db2inst1 owner
su - db2inst1
db2level
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL12011" with level
identifier "02020110".
Informational tokens are "DB2 v12.1.1.0", "s2412161033", "DYN2412161033AMD64",
and Fix Pack "0".
Product is installed at "/opt/ibm/db2/V12.1".
And start the instance
db2start
04/09/2025 14:12:40 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
Creating the SAMPLE database
db2sampl
Creating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema "DB2INST1"...
'db2sampl' processing complete.
and connect to the SAMPLE database.
db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 12.1.1.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE