A pre-built Docker image is provided on the official TPC site on Docker Hub at https://hub.docker.com/u/tpcorg that can be downloaded with the docker pull command either for a complete image for all databases but also database-specific images.

docker pull tpcorg/hammerdb
docker pull tpcorg/hammerdb:mysql
docker pull tpcorg/hammerdb:maria
docker pull tpcorg/hammerdb:oracle
docker pull tpcorg/hammerdb:postgres
docker pull tpcorg/hammerdb:mssqls

The official HammerDB Docker images are hosted by the TPC-Council.

Figure 1.12. HammerDB Docker Hub

It is only necessary to follow the Dockerfile build instructions if you wish to build your own Docker images from source.

A Dockerfile is a shell script that automates the docker container build. It makes it easier to spawn multiple containers with ease. HammerDB source on GitHub is packaged with a folder “Docker”, that contains all the Docker related files and folders. This folder contains a Dockerfile for building a HammerDB client container that supports all the databases that HammerDB supports, i.e. Oracle, Microsoft SQL Server, IBM Db2, MySQL, PostgreSQL and MariaDB. The Dockerfile is easy to customise for individual requirements.

The HammerDB Dockerfile is stored within the HammerDB GitHub repository. To download the Dockerfile either clone or download the ZIP file of the HammerDB source and navigate to the Docker directory.

Figure 1.13. Docker File Download

The Docker container built from this Dockerfile installs the required third-party driver libraries for all databases supported in HammerDB except for IBM Db2. As IBM Db2 client libraries are not free to redistribute they must be independently downloaded and added if required. For the build to include IBM Db2, IBM Data Server Driver for ODBC and CLI can be downloaded locally and placed in the same location as Dockerfile.

To create an image: Change to the directory containing the Dockerfile and run the docker build command.

docker build -t hammerdb-v6.0 . 

Figure 1.14. Docker Build

Figure 1.15. Successfully built

To create and start a container named "hammerdb" with the image built in the previous section, run the following command. The container build is successful, but the client libraries for IBM are not installed.

	docker run -it --name hammerdb hammerdb-v6.0 bash

Figure 1.16. Docker Run

If IBM client libraries are manually downloaded and placed alongside the Dockerfile, the container builds successfully and the output looks as follows.

12.4.1. IBM Client Install

If IBM client libraries are manually downloaded and placed alongside the Dockerfile, the container builds successfully and the output looks as follows.

Figure 1.17. IBM Client

The Docker container needs to be connected to the network to communicate with remote databases. The following is an example of adding host network to the container.

 docker run --network=host -it --name hammerdb hammerdb-v6.0 bash