How to Install DB2 V10.5 using GUI
Table of Contents
___________________________________________________________________________________________________
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
___________________________________________________________________________________________________
OS | Linux 7.5 |
---|---|
Memory | 8G |
Swap | 8G |
Disk | 70G |
DB2 Version | 10.5.0.10 |
DB2 Installation Path | /u01/IBM/db2/V10.5 |
DB2 Instance owner | db2inst1 |
Group Name | db2iadm1 |
fence user | db2fenc1 |
Group Name | db2fadm1 |
Instance Name | db2inst1 |
Port Number | 50000 |
[root@pcs1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)
[root@pcs1 ~]#
Download DB2 from www.ibm.com
[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;
[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. [root@pcs1 server_t]#
[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]#
[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 internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/
Reference: