DB2 Warehouse - stanislawbartkowski/wikis GitHub Wiki

DB2 Warehouse on podman

Source of truth: https://www.ibm.com/support/knowledgecenter/SSCJDQ/com.ibm.swg.im.dashdb.kc.doc/welcome.html

Installation

Obtain API key:

https://www.ibm.com/support/knowledgecenter/SSCJDQ/com.ibm.swg.im.dashdb.doc/admin/get_image.html

Log on using the key.

sudo echo <apikey> | docker login -u iamapikey --password-stdin icr.io

Pull the image as superuser.

sudo podman pull icr.io/obs/hdm/db2wh_ee:v11.5.5.0-db2wh-linux

Collect information about storage.

DB2 Warehouse mount point Description Local volume (example)
/mnt/bludata0 Data container and log directory /var/db2warehouse
/mnt/blumeta0 Catalog, metadata (can be the same as data) /var/db2warehouse
/mnt/backup Backup catalog (optional) /var/db2warehousebackup

Start the container as a superuser.

sudo mkdir /var/db2warehouse

sudo podman run -dit --privileged=true --name=db2wh -v /var/db2warehouse:/mnt/bludata0 -v /var/db2warehouse:/mnt/blumeta0 -p 50000:50000 -p 50001:50001 -p 8443:8443 icr.io/obs/hdm/db2wh_ee:v11.5.5.0-db2wh-linux


sudo podman run --net=host -dit --privileged=true --name=db2wh -v /var/db2warehouse:/mnt/bludata0 -v /var/db2warehouse:/mnt/blumeta0 icr.io/obs/hdm/db2wh_ee:v11.5.5.0-db2wh-linux


sudo podman run --net=host -dit --privileged=true --name=db2wh -v /var/db2warehouse:/mnt/bludata0 -v /var/db2warehouse:/mnt/blumeta0 -v /var/db2warehousebackup:/mnt/backup icr.io/obs/hdm/db2wh_ee:v11.5.5.0-db2wh-linux

It takes up to 15 minutes to get the container ready.

sudo podman logs db2wh

[102216.065789] start_dashDB_local.sh[61]: * Next steps:
[102216.067797] start_dashDB_local.sh[61]: *
[102216.069801] start_dashDB_local.sh[61]: * 1. If you were monitoring the container startup progress using docker logs
[102216.071772] start_dashDB_local.sh[61]: command, use Ctrl+c key-sequence to detach from the Docker logs console.
[102216.073794] start_dashDB_local.sh[61]: * 3. Log in to the web console using the following information:
[102216.075790] start_dashDB_local.sh[61]: *        URL: https://10.88.0.3:8443
[102216.077796] start_dashDB_local.sh[61]: *        Default user ID    : bluadmin
*        Default password   : eZ@U7kMys91jPxdGEQ2DeMXxEv_m3
[102217.052765] start_dashDB_local.sh[61]: * 4. For improved security, change the default bluadmin password
[102217.054850] start_dashDB_local.sh[61]: *        by running "docker exec -it Db2wh setpass <new password>".
[102217.056880] start_dashDB_local.sh[61]: *        For other user management, use the web console.
[102217.120904] start_dashDB_local.sh[61]: * Note: Db2wh is an example of a container name. Use the container name
[102217.121232] start_dashDB_local.sh[61]: that you specified for the docker run command.
[102217.123018] start_dashDB_local.sh[61]: *

Logon to the console using credentials provided, bluadmin/<password>

Client container

https://www.ibm.com/support/knowledgecenter/SSCJDQ/com.ibm.swg.im.dashdb.doc/admin/deploying_client_container.html

Log on using the key.

sudo echo <apikey> | docker login -u iamapikey --password-stdin icr.io

Pull the image (as superuser).

sudo podman pull icr.io/obs/hdm/db2wh_ce:v11.5.5.0-db2wh_client-linux

Create container (as superuser).

sudo mkdir -p /var/db2warehouse/clientdir
sudo podman run --net=host -dit -v /var/db2warehouse/clientdir:/mnt/clientdir -v /var/db2warehouse/home/db2inst1:/mnt/blumeta0/home/db2inst1 --name=client icr.io/obs/hdm/db2wh_ce:v11.5.5.0-db2wh_client-linux

To set up a connection to local DB2 Warehouse, identify podman network, here 10.88.0.1

ip addr

6: cni-podman0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000
    link/ether 0a:80:4b:7d:cc:ef brd ff:ff:ff:ff:ff:ff
    inet 10.88.0.1/16 brd 10.88.255.255 scope global cni-podman0

Enter client container.

sudo podman exec -it -u db2inst1 client bash

[Db2wh - Client CLI /]\> 

Catalog DB2 Warehouse database.

db_catalog --add 10.88.0.1:50000 --alias BLUDB
db2 list db directory

System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = BLUDB
 Database name                        = BLUDB
 Node name                            = DB2WH_25
 Database release level               = 15.00
 Comment                              =
 Directory entry type                 = Remote
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =

db2 connect to BLUDB user db2inst1 using secret

Useful commands

CLPPLus, command line

podman exec -it db2wh clpplus bluadmin/<password>@<hostname>:50000/BLUDB

Example.

podman exec -it db2wh clpplus bluadmin/bluadmin@localhost:50000/BLUDB

Change password for bludadmin user

podman exec -it db2wh setpass <password>

DB2 Warehouse status

podman exec -it db2wh status

⚠️ **GitHub.com Fallback** ⚠️