How to install IBM Db2 Developer Edition on Centos 7 using Docker

In this post, I would like to show you how to install IBM Db2 Developer Community edition. IBM Db2 Developer Community Edition is a full-featured free version for non-production environments. Primarily it is dedicated to developers and has some limitations:

• 4 cores
• 16GB memory
• 100GB database size

It is available for Mac, Windows, and Linux as a Docker or Non-Docker installation. It can be used both for standalone and clustered installations.

We will also install Data Server Manager, which is a successor to the IBM Data Studio Web Console.

This demo requires a basic knowledge of Docker (or generally containers – no commands needed, just principles) and the ability to install Centos 7 operating system.

For more information, go to the following link, where you can also download installation packages:

https://www.ibm.com/us-en/marketplace/ibm-db2-direct-and-developer-editions

Log in with your IBM ID, accept the license and check the I agree checkbox.

Download the edition for Linux x86.

When you finish the download, it is necessary to prepare the virtual machine for the Db2 installation. As you know, the resources for this version of IBM Db2 are limited; but generally, the more resources you allocate to the database the better performance it has, so allocate to the virtual machine as much of each of the resources as possible. Here is my configuration:

I use VMware Workstation, but any other tool (such as VirtualBox) would be sufficient.

Prepare Centos 7 installation with the latest updates and no other supplements on this virtual machine with at least 1 admin non-root user.

Log in to a virtual machine as a non-root user (in my case, it is devuser).

Upload the AppImage file that you downloaded from the IBM pages and open the terminal.

Update the package database:

sudo yum check-update

Install Docker repository. Download the latest version of Docker and install it. This may take several minutes.

curl -fsSL https://get.docker.com/ | sh

Final output:

Add a user to the docker group to be able to execute the Docker commands.

sudo usermod -aG docker devuser

Be sure to use your user in the command above!

Verify Docker status to see if it runs:

sudo systemctl status docker

Enable Docker to start automatically during the booting of the system.

sudo systemctl enable docker

If you issue the command…

docker info

…You will receive a “permission denied” error. This is because the group membership was not reloaded. So, if you issue the command…

id

…You will see that the docker group is not listed. There is a workaround for this. Just open a new shell with a command

su - $USER

The system will ask for the password. When you issue the id command again, you will see the docker group in the list.

When you run the command docker info again, you should see something like this at the end of the output.

Check if you have opened the ports 11080-11082 and 50000.

sudo firewall-cmd --list-ports

To open these ports run the following commands:

sudo firewall-cmd --zone=public –-permanent --add-port=50000/tcp
sudo firewall-cmd --zone=public --permanent --add-port=11080-11082/tcp
Port 50000 is for Db2; ports 11080-11082 are for Data Server Manager.

The following two commands list open ports and reload the configuration of the firewall.

sudo firewall-cmd --permanent --list-ports
sudo firewall-cmd --reload

Move to the location where the AppImage is stored. Be sure that the file has an executable privilege. If not, use chmod command to change it.

chmod u+x ./ibm-db2-developer_community_edition-1.1.0-x86_64.AppImage

docker ps

docker exec -it a62c1583a756 bash -c 'su - db2inst1'

db2 connect to sample