Db2

Expand all | Collapse all

DB2 Warehouse Docker Install Fails

  • 1.  DB2 Warehouse Docker Install Fails

    Posted Sun March 24, 2019 02:07 PM
    Edited by System Fri January 20, 2023 04:25 PM
    Hello. I am an IBM Business Partner trying to prepare my environment for a POC during the week of 3/25/19. I have downloaded the DB2 Warehouse for Windows trial code from here: https://www.ibm.com/analytics/us/en/db2/trials/#data_warehouse .  I also downloaded Docker from the Docker website. I've got Docker installed under Windows 10 successfully. But every time I try to install DB2, I receive the following sequence of messages and errors:

    [ 4823.101995] start_dashDB_local.sh[76]: Running 'Cgroup filesystem mount existence' test...

    [ 4834.587272] start_dashDB_local.sh[76]: Running 'Platform sanity' test...

    [ 4834.696746] start_dashDB_local.sh[76]: Running 'Docker storage driver' test...

    [ 4834.702704] start_dashDB_local.sh[76]: Running 'SELinux status' test...

    [ 4834.807963] start_dashDB_local.sh[76]: Running 'Root volume total-space' test...

    [ 4835.273793] start_dashDB_local.sh[76]: IBM Db2 Warehouse configuration: SMP

    [ 4835.373911] start_dashDB_local.sh[76]: Successfully set timezone to UTC

    [ 4835.744825] start_dashDB_local.sh[76]: Unable to discover the domain from static hostname.

    [ 4851.104888] start_dashDB_local.sh[76]: Checking if the initialization has been done previously ...

    [ 4851.111748] start_dashDB_local.sh[76]: IBM Db2 Warehouse stack is NOT initialized yet.

    [ 4854.708835] start_dashDB_local.sh[76]: configure_user_management completed successfully.

    [ 4855.425632] start_dashDB_local.sh[76]: Creating IBM Db2 Warehouse instance and directories

    [ 4857.051270] start_dashDB_local.sh[76]: IBM Db2 Warehouse instance creation failed.

    [ 4857.052122] start_dashDB_local.sh[76]: Retry the operation. If the same failure occurs, contact IBM Service.

    [ 4857.052895] start_dashDB_local.sh[76]: If a command prompt is not visible on your screen, you need to detach from the container by typing Ctrl-C.

    [ 4857.056375] start_dashDB_local.sh[76]: IBM Db2 Warehouse installation failed. Retry the operation by re-deploying a container.

    [ 4857.061510] start_dashDB_local.sh[76]: * If this is an initial deployment:

    [ 4857.062453] start_dashDB_local.sh[76]: a) Remove the container using the 'docker rm -f Db2wh' command.

    [ 4857.062968] start_dashDB_local.sh[76]: b) Remove the image using the 'docker rmi <image>' command.

    [ 4857.063427] start_dashDB_local.sh[76]: c) Delete the contents of the mounted host volume specified in the docker run command

    [ 4857.063899] start_dashDB_local.sh[76]: (e.g. docker run ... -v <host volume>:/mnt/bludata0)

    [ 4857.064365] start_dashDB_local.sh[76]: Note: THIS WILL RESULT IN DATA LOSS

    [ 4857.064906] start_dashDB_local.sh[76]: d) Redeploy the image.

    [ 4857.065430] start_dashDB_local.sh[76]: Note: Db2wh is an example of a container name. Use the container name

    [ 4857.065846] start_dashDB_local.sh[76]: that you specified for the docker run command.

    [ 4857.069493] start_dashDB_local.sh[76]: If the same failure occurs, contact IBM Service.

    [ 4857.165510] start_dashDB_local.sh[76]: Running 'Docker storage driver' test...

    [ 4857.249355] start_dashDB_local.sh[76]: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    [ 4857.253698] start_dashDB_local.sh[76]: FATAL RUNTIME ERROR DETECTED

    [ 4857.257736] start_dashDB_local.sh[76]: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    [ 4857.262235] start_dashDB_local.sh[76]: Dumping system configuration details to help diagnose the problem

    [ 4857.359044] start_dashDB_local.sh[76]: Running 'Docker storage driver' test...

    [ 4857.379552] start_dashDB_local.sh[76]: Generation of diagnostic information complete; stopping deployment of container immediately

    I've tried (given a rudimentary knowledge of Docker) removing the containers, removing the image, deleting the volumes, and reinstalling DB2, but the same error occurs. It looks to me like it's failing in the instance creation process.

    Can anyone help?

    Larry Edelstein



    ------------------------------
    Larry Edelstein, Saturn Business Systems
    ------------------------------
    #Db2


  • 2.  RE: DB2 Warehouse Docker Install Fails

    Posted Sun March 24, 2019 02:38 PM
    Larry, check if you have fully qualified hostname in server hosts file. Maybe instance creation failed because of that. It should be like for eg.:

    192.0.2.214 Db2whblu1.example.com Db2whblu1

    Then, restart server and try to redeploy container from scratch. 

    Regards,
    Ivan

    ------------------------------
    Ivan Milojevic
    Comtrade System Integration
    Belgrade
    ------------------------------



  • 3.  RE: DB2 Warehouse Docker Install Fails

    Posted Sun March 24, 2019 08:18 PM
    Edited by System Fri January 20, 2023 04:35 PM
    Thank you Ivan. But what if the db2wh container is to be installed on the local server and it is not part of any domain? It is a local laptop Windows 10 server on my home network.

    In any case, I tried creating an entry in my etc\hosts file that was just

    Db2wh     192.168.1.4

    Rebooted, redeployed ... same exact result ... unable to create instance.

    ------------------------------
    Larry Edelstein
    ------------------------------



  • 4.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 05:53 AM
    Larry,

    When I tried the Windows version of WarehouseDB I ran into issues every other day where the docker image would get corrupted. I would strongly recommend doing a Unix VM instead. Use vmware and use the memory and cpu requirements. You will get alot farther going this route. Are you planning on just SMP or a MPP implementation for your POC ?

    ------------------------------
    frank pantaleo
    ------------------------------



  • 5.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 09:07 AM

    Thanks, Frank.

    Right now, I don't have acccess to any Linux images that I can use for a VM. I'm planning just for SMP.

    Larry



    ------------------------------
    Larry Edelstein
    ------------------------------



  • 6.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 10:05 AM
    Larry,

    Easily solved. Use the centos (99% binary same as Redhat) at any of the centos.org mirrors. I use this one http://mirrors.rit.edu/centos/7.6.1810/isos/x86_64/. Pick up a everything iso like CentOS-7-x86_64-Everything-1810.iso. Then just install the freeware VM player and use the iso when building the vm environment for the server. I would suggest about 16gb if you have a good  machine you can use a couple of CPU's as well. If you are doing SMP POC you may be able to just side step the GPFS requirement to make the build easier to construct. I have a white paper on how to build a MPP on VM's if interested.

    ------------------------------
    frank pantaleo
    ------------------------------



  • 7.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 10:10 AM
    Thank you Frank. I have a fully licensed VMWARE Workstation and my machine is a 4-way 64GB. So all of that shouldn't be an issue. GPFS is another matter.

    ------------------------------
    Larry Edelstein
    ------------------------------



  • 8.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 10:19 AM
    If you want to get a feel for the software skip GPFS. Also I found that IBM support was ok with NFS so if you can use a redhat/centos unix filesystem that allows expansion this could work ok in a SMP or MPP implementation. You won't have GPFS snapshot so you will be forced to do cold backups or the new schema based backup. Of the options available now the schema option works great and is portable which is alot more than you can say for GPFS.

    ------------------------------
    frank pantaleo
    ------------------------------



  • 9.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 10:34 AM
    Actually all I really need is the engine. Won't need to do backups or HA.

    ------------------------------
    Larry Edelstein
    ------------------------------



  • 10.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 10:59 AM
    If your POC objective is to get a better understanding of the engine doing a SMP without GPFS should be a fairly quick and easy path. You can do all of that with a single VM using Centos with the 16gb (or more) memory, CPU, and I have been using 100gb. This should allow you to get a full feel for the engine and SQL interactions.

    ------------------------------
    frank pantaleo
    ------------------------------



  • 11.  RE: DB2 Warehouse Docker Install Fails

    Posted Mon March 25, 2019 12:52 PM
    Thanks again, Frank. Unfortunately, I'm going to have to go back to Windows and figure out how to get it done there. My VMWARE won't boot the CentOS image - it claims VMware Workstation and Device/Credential Guard are not compatible. But Device Guard isn't enabled. Crazy.

    ------------------------------
    Larry Edelstein
    ------------------------------



  • 12.  RE: DB2 Warehouse Docker Install Fails

    Posted Tue March 26, 2019 12:39 PM
    So just FYI in case anyone reads this thread. When you install Docker on Windows 10, it enables hyper-v virtualization settings in the BIOS. The only problem is that these virtualization settings are incompatible with running a VM under VMWARE. The message received under VMWARE is related to VMware Workstation and Device/Credential Guard not being compatible. But Windows Device Guard isn't enabled.

    You have to go into your virtualization settings and disable hyper-v and you will then be able to boot your VMs again.

    Larry

    ------------------------------
    Larry Edelstein
    ------------------------------