Deploy IBM® Db2® Warehouse to a single-node
symmetric multiprocessing (SMP) system that runs on Linux®
and uses x86 hardware.
Procedure
-
Ensure that you have root authority on the host operating system.
-
Refer to Configuration options and note any options whose default settings
need to be overridden. Later in this procedure, you will be instructed to specify the new
settings.
-
Log in to Docker or Podman by using your API key:
echo <apikey> | docker login -u iamapikey --password-stdin icr.io
echo <apikey> | podman login -u iamapikey --password-stdin icr.io
where
<apikey> is the API key that you created as a prerequisite in
Getting container images.
Note:
On Ubuntu, the error below will be returned when attempting to login to Docker using
sudo:
Permission denied while trying to connect to the Docker daemon socket at
unix:///var/run/docker.sock: Post http://%2Fvar%2Frun%2Fdocker.sock/v1.24/auth: dial unix
/var/run/docker.sock: connect: permission denied.
Resolve by adding user to the Docker group.
- sudo usermod -a -G docker
- Logout, then log back into the system.
-
Issue one of following docker run or podman run commands
to pull, create, and initialize the latest Db2 Warehouse
container.
Note: If necessary, add to this command one
-e parameter for each
configuration option that is to be set during deployment. See
Configuration options for more information. For example, both enable Spark and use
row-organized storage, include the following option settings in your
docker run / podman
run command:
-e DISABLE_SPARK=NO -e TABLE_ORG=ROW
Issue the
following
docker run or
podman run commands:
- For a Db2 Warehouse Enterprise
Edition
container:
docker run -d -it --privileged=true --net=host --name=Db2wh -v /mnt/clusterfs:/mnt/bludata0 -v /mnt/clusterfs:/mnt/blumeta0 icr.io/obs/hdm/db2wh_ee:v11.5.7.0-cn5-db2wh-linux
podman run -d -it --privileged=true --net=host --name=Db2wh -v /mnt/clusterfs:/mnt/bludata0 -v /mnt/clusterfs:/mnt/blumeta0 icr.io/obs/hdm/db2wh_ee:v11.5.7.0-cn5-db2wh-linux
-
Issue one of the the following commands to check whether the deployment is progressing
successfully:
docker logs --follow Db2wh
podman logs --follow Db2wh
-
After the deployment finishes, a message indicates the web console URL and login information.
Note this information for later.
-
Exit the Docker logs by pressing Ctrl+C.
-
Set a new password for the bluadmin user by issuing the following command:
docker exec -it Db2wh setpass new_password
podman exec -it Db2wh setpass new_password
-
Log in to the web console using the web console URL that was displayed in Step 6. The URL has the form
https://IP_address:8443.