Tuesday, July 30, 2024

Install DB2 V10.5 using GUI

 Table of Content:

1. Hardware Requirements

2. Verify OS version

3. Download DB2 software

4. Untar Software

5. DB2 Installation Prerequisites

6. Set the DISPLAY Environment

7. Invoke ./db2setup

8. Validation

9. Verification

1. Hardware Requirements

2. Verify OS version

[root@pcs1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)
[root@pcs1 ~]#

3. Download Software

Download DB2 from www.ibm.com


4. Untar Software

[root@pcs1 ~]# mkdir -p /u01/IBM/db2
[root@pcs1 stage]# tar -xvf v10.5fp10_linuxx64_server_t.tar.gz -C /u01/IBM/db2

[root@pcs1 stage]# cd /u01/IBM/db2
[root@pcs1 db2]# ls -ltr
total 4
drwxr-xr-x. 5 root root 4096 Jul  4  2018 server_t
[root@pcs1 db2]# cd server_t
[root@pcs1 server_t]# ls -ltr
total 116
drwxr-xr-x.  4 root root    84 Jul  4  2018 nlpack
-r-xr-xr-x.  1 bin  bin   5642 Jul  4  2018 db2prereqcheck
-r-xr-xr-x.  1 bin  bin   5798 Jul  4  2018 db2_deinstall
-r-xr-xr-x.  1 bin  bin   5650 Jul  4  2018 db2setup
-r--r--r--.  1 bin  bin  41540 Jul  4  2018 db2checkCOL.tar.gz
-r-xr-xr-x.  1 bin  bin   5632 Jul  4  2018 db2ls
-r--r--r--.  1 bin  bin   4987 Jul  4  2018 db2checkCOL_readme.txt
-r-xr-xr-x.  1 bin  bin   5883 Jul  4  2018 db2ckupgrade
-r-xr-xr-x.  1 bin  bin   5668 Jul  4  2018 db2_install
-r-xr-xr-x.  1 bin  bin   5686 Jul  4  2018 installFixPack
drwxr-xr-x. 10 bin  bin   4096 Jul  4  2018 ibm_im
drwxr-xr-x.  6 bin  bin   4096 Jul  4  2018 db2
[root@pcs1 server_t]#


5. DB2 Installation Prerequisites

[root@pcs1 server_t]# ls -ltr db2prereqcheck
-r-xr-xr-x. 1 bin bin 5642 Jul  4  2018 db2prereqcheck
[root@pcs1 server_t]#
[root@pcs1 server_t]# ./db2prereqcheck
..............
..............
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.5".


DBT3563E  The db2prereqcheck utility determined that SELinux is enabled, which is not supported with GPFS.

[root@pcs1 server_t]#


6. Set the DISPLAY Environment

If you are using X emulation then set the DISPLAY environmental variable.

[root@pcs1 server_t]# export DISPLAY=192.168.2.1:0.0;


7. Invoke ./db2setup

[root@pcs1 server_t]# ls -ltr
total 116
drwxr-xr-x.  4 root root    84 Jul  4  2018 nlpack
-r-xr-xr-x.  1 bin  bin   5642 Jul  4  2018 db2prereqcheck
-r-xr-xr-x.  1 bin  bin   5798 Jul  4  2018 db2_deinstall
-r-xr-xr-x.  1 bin  bin   5650 Jul  4  2018 db2setup
-r--r--r--.  1 bin  bin  41540 Jul  4  2018 db2checkCOL.tar.gz
-r-xr-xr-x.  1 bin  bin   5632 Jul  4  2018 db2ls
-r--r--r--.  1 bin  bin   4987 Jul  4  2018 db2checkCOL_readme.txt
-r-xr-xr-x.  1 bin  bin   5883 Jul  4  2018 db2ckupgrade
-r-xr-xr-x.  1 bin  bin   5668 Jul  4  2018 db2_install
-r-xr-xr-x.  1 bin  bin   5686 Jul  4  2018 installFixPack
drwxr-xr-x. 10 bin  bin   4096 Jul  4  2018 ibm_im
drwxr-xr-x.  6 bin  bin   4096 Jul  4  2018 db2
[root@pcs1 server_t]#
[root@pcs1 server_t]#
[root@pcs1 server_t]# ./db2setup
Requirement not matched for DB2 database "Server" . Version: "10.5.0.10".

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".


DBI1190I  db2setup is preparing the DB2 Setup wizard which will guide
      you through the program setup process. Please wait.

8. Validation

[root@pcs1 server_t]# /u01/IBM/db2/V10.5/bin/db2val
DBI1379I  The db2val command is running. This can take several minutes.

DBI1335I  Installation file validation for the DB2 copy installed at
      /u01/IBM/db2/V10.5 was successful.

DBI1343I  The db2val command completed successfully. For details, see
      the log file /tmp/db2val-220423_131019.log.


[root@pcs1 server_t]#

9. Verification

[db2inst1@pcs1 ~]$ id
uid=54323(db2inst1) gid=101(db2iadm1) groups=101(db2iadm1)
[db2inst1@pcs1 ~]$
[db2inst1@pcs1 ~]$ db2level
DB21085I  This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL1005A" with level
identifier "060B010E".
Informational tokens are "DB2 v10.5.0.10", "s180615", "IP24053", and Fix Pack
"10".
Product is installed at "/u01/IBM/db2/V10.5".

[db2inst1@pcs1 ~]$
[db2inst1@pcs1 ~]$ db2ls

Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID
---------------------------------------------------------------------------------------------------------------------
/u01/IBM/db2/V10.5              10.5.0.10       10                            Sat Apr 23 12:57:17 2022 +08             0
[db2inst1@pcs1 ~]$
[db2inst1@pcs1 ~]$ ps -ef | grep db2
root      2899     1  0 12:58 ?        00:00:00 db2wdog 0 [db2inst1]
db2inst1  2901  2899  0 12:58 ?        00:00:02 db2sysc 0 <---
root      2907  2899  0 12:58 ?        00:00:00 db2ckpwd 0
root      2908  2899  0 12:58 ?        00:00:00 db2ckpwd 0
root      2909  2899  0 12:58 ?        00:00:00 db2ckpwd 0
db2inst1  2911  2899  0 12:58 ?        00:00:00 db2vend (PD Vendor Process - 1) 0
db2inst1  2920  2899  0 12:58 ?        00:00:01 db2acd 0 ,0,0,0,1,0,0,0,0000,1,0,995db8,14,1e014,2,0,1,41fc0,0x210000000,0x210000000,1600000,30003,2,c0013
root     19016  6539  0 13:13 pts/1    00:00:00 su - db2inst1
db2inst1 19017 19016  0 13:13 pts/1    00:00:00 -bash
db2inst1 20146 19017  0 13:17 pts/1    00:00:00 ps -ef
db2inst1 20147 19017  0 13:17 pts/1    00:00:00 grep --color=auto db2
root     27033     1  0 12:57 ?        00:00:00 /u01/IBM/db2/V10.5/bin/db2fmcd
[db2inst1@pcs1 ~]$

[db2inst1@pcs1 ~]$ db2ilist
db2inst1
[db2inst1@pcs1 ~]$
[db2inst1@pcs1 ~]$ db2 get instance

 The current database manager instance is:  db2inst1

[db2inst1@pcs1 ~]$

[db2inst1@pcs1 ~]$ db2licm -l
Product name:                     "DB2 Advanced Enterprise Server Edition"
License type:                     "Trial"
Expiry date:                      "07/21/2022"
Product identifier:               "db2aese"
Version information:              "10.5"

[db2inst1@pcs1 ~]$

[db2inst1@pcs1 ~]$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 10.5.10

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 =>
db2 => quit
DB20000I  The QUIT command completed successfully.
[db2inst1@pcs1 ~]$
[db2inst1@pcs1 ~]$ db2 list db directory
SQL1031N  The database directory cannot be found on the indicated file system.
SQLSTATE=58031
[db2inst1@pcs1 ~]$

DB2 export and import

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested individually; however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.