Public Repository

Last pushed: 2 years ago
Short Description
DB2 Server trial edition
Full Description

IMPORTANT NOTICE:
THIS REPO IS NOT AVAILABLE FOR NOW DUE TO HOUS KEEPING. PLEASE EMAIL TO kishore.nalam@in.ibm.com IF YOU NEED ANY IMMEDIATE HELP

What is IBM DB2 Server Evaluation Edition ?

``IBM DB2 Server Evaluation Edition``` is the fully functional Trial edition of DB2 server, offers accelerated analytic processing by introducing a new processing paradigm and data format within the DB2 database product. Advantages include significant reductions in time-to-value and increased consumability, which can be achieved through minimal DBA design requirements and reduced query tuning and debugging efforts. Industry-leading compression, large performance gains for analytic queries, and large reductions in performance variation round out the benefits of deploying this technology.

  • Uses Time Travel Query to provide bi-temporal data management.
  • Delivers an integrated tools environment with IBM Data Studio for easier management and development.
  • Includes Graph Store technology to efficiently store graph triples for reduced costs and enhanced performance.
  • Contains the SQL Compatibility feature making it easier to run applications written for other major databases, on DB2.

DB2 column-organized tables:

DB2 Version 10.5 introduces compressed column-organized tables for DB2 databases. The release also includes broad support for data mart (analytic) workloads with complex queries that are commonly characterized by multi-table joins, grouping and aggregation, and table scans over a star schema.

SQL compatibility :

If you work with relational database products other than DB2 products,V10.5 builds on existing functionality, interfaces, and compatibility features to provide additional enhancements that make DB2 products more familiar to you. These enhancements reduce the time and complexity of enabling applications that are written for other relational database products to run quickly in a DB2 environment.

DB2 for Linux, UNIX and Windows

Supported tags

  • latest (`10.5.0.5-3.16.0)
  • 10.5.0.5-3.16.0,

The supported tags stands for <db2 version> - <Linux kernel version of Docker Engine>.
DB2 Docker images can be deployed on a Docker Engine with any flavour of Linux , as long as it has the compatible Linux kernel-3.16.0.Not tested on other kernels.

  • Please make sure your Docker Engine has a compatible Linux kernel
  • Please use Docker 1.6.0 or later release on Ubuntu Docker Engine

How to use this image ?

This docker image has to be deployed to Docker Engine on one of supported Cloud providers or your own system. The instructions for creating Docker Engine vary by Cloud provider. We recommend to use Docker Machine (beta) to provision Docker Engine.

In order to use the image, it is necessary to accept the terms of the DB2 Server Trail license. This is achieved by specifying the environment variable LICENSE equal to accept when running the image.

This docker image contained pre-deployed DB2 Sever Install with the required script to create your first instance, db2inst1.

1 - Start a container

docker run -it --privileged -p 50000:50000 -e LICENSE=accept ibmcom/db2-server-trial:latest /bin/bash
  • -p 50000:50000 exposes port 50000 to allow connections from the remote client.
  • By specifying -e LICENSE=accept parameter, you are accepting this License to use the software contained in this image.
  • --privileged allows DB2 instance in Docker Engine to manage kernel configuration.

2 - Create DB2 Instance and create sample DB
Please switch to the default db2 instance user db2inst1 to start DB2 instance and create a sample database if you want :

$ cd /tmp/db2_conf
$ chmod 755 createInstance
$ ./createInstance
$ su - db2inst1
$ db2start
$ db2sampl
  • The time of creating a sample database depends on your system performance, which may take several minutes.
  • You can create another database using db2 create db <dbname> command.

3 - Note

1) Mount a volume
While starting a Docker container, you can mount a volume from a directory on the Docker host like the following command :

docker run -it -p 50000:50000 -e LICENSE=accept -v $(pwd):/share ibmcom/db2server:latest bash
  • /share, referring to mount point at "/share" in the Docker.
  • $(pwd), the current directory on Docker host while running Docker command, which is mounted by Docker container. It can also be any existing directory on Docker host, like /tmp, /opt, etc.

2) DB2 is deployed in the Docker Engine in:

/opt/ibm/db2/V10.5

License

The Dockerfile and associated scripts are licensed under the Apache License 2.0. DB2 Server is licensed under the IBM International License Agreement for Non-Warranted Programs. This license for DB2 Server can be found online. Note that this license does not permit further distribution.

Supported Docker versions

  • This image is officially supported on Docker version 1.6.0.
  • Support for older versions (down to 1.0) is provided on a best-effort basis.

Community Support

Like this image? Give us a star at the top of this page!

Docker Pull Command
Owner
ibmcom