Deploying IBM Db2 Warehouse SMP on Linux and x86 hardware

Deploy IBM® Db2® Warehouse to a single-node symmetric multiprocessing (SMP) system that runs on Linux® and uses x86 hardware.

Before you begin

If you previously installed Db2 Warehouse on your current hardware, do not follow this procedure. Instead, redeploy Db2 Warehouse by following the procedure described in Redeploying IBM Db2 Warehouse on Linux.

Ensure that your Linux system meets the hardware prerequisites described in IBM Db2 Warehouse prerequisites for Linux and x86 hardware.

Ensure that your Linux system meets the prerequisites described in Getting container images.

Procedure

  1. Ensure that you have root authority on the host operating system.
  2. 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.
  3. 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.

    1. sudo usermod -a -G docker
    2. Logout, then log back into the system.
  4. 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
  5. Issue one of the the following commands to check whether the deployment is progressing successfully:
    docker logs --follow Db2wh
    podman logs --follow Db2wh
  6. After the deployment finishes, a message indicates the web console URL and login information. Note this information for later.
  7. Exit the Docker logs by pressing Ctrl+C.
  8. 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
  9. 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.