Db2 Warehouse (On Premises and Cloud)

nested-group-icon.png

DB2

Failed to install Db2 Warehouse Developer Edition V3.6 on RHEL7

  • 1.  Failed to install Db2 Warehouse Developer Edition V3.6 on RHEL7

    Posted Tue May 21, 2019 08:58 AM
    Hi all,

    Tried to install Db2 Warehouse Developer V3.6 from IBM Db2 Warehouse Developer Edition on my Red Hat Enterprise Linux Workstation release 7.6 (Maipo), "IBM Open Client for Linux".  Then got error messages and failed installation.

    Would you experts here give any advice to myself, please? What's New in IBM Db2 Warehouse says that base CentOS was upgraded since db2wh V3.5. Would it be a possible cause for this failure?


    docker logs --follow Db2wh

    [77088.894072] start_dashDB_local.sh[61]: IBM Db2 Warehouse configuration: SMP
    [77089.253036] start_dashDB_local.sh[61]: Successfully set timezone to UTC
    [77093.209445] start_dashDB_local.sh[61]: Checking if the initialization has been done previously ...
    [77093.222385] start_dashDB_local.sh[61]: IBM Db2 Warehouse stack is NOT initialized yet.
    [77118.514458] start_dashDB_local.sh[61]: configure_user_management completed successfully.
    [77123.978478] start_dashDB_local.sh[61]: Creating IBM Db2 Warehouse instance and directories
    [77224.958045] start_dashDB_local.sh[61]: Initialize IBM Db2 Warehouse instance to use up to 80% of the memory assigned to container namespace
    [77278.548113] start_dashDB_local.sh[61]: Configuring IBM Db2 Warehouse for COLUMN storage...
    [77290.669601] start_dashDB_local.sh[61]: database SSL configuration
    [77327.266794] start_dashDB_local.sh[61]: rc=255, error='Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
    [77327.267464] start_dashDB_local.sh[61]: ', output=
    [77330.161501] start_dashDB_local.sh[61]: rc=255, error='Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
    [77330.161917] start_dashDB_local.sh[61]: ', output=
    ........
    [77408.421035] start_dashDB_local.sh[61]: rc=255, error='Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
    [77408.421465] start_dashDB_local.sh[61]: ', output=
    [77411.108722] start_dashDB_local.sh[61]: rc=255, error='Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
    [77411.109126] start_dashDB_local.sh[61]: ', output=
    [77411.134355] start_dashDB_local.sh[61]: Starting IBM Db2 Warehouse engine failed.
    [77411.154734] start_dashDB_local.sh[61]: IBM Db2 Warehouse installation failed. Retry the operation by re-deploying a container.
    [77411.165968] start_dashDB_local.sh[61]: * If this is an initial deployment:
    [77411.166446] start_dashDB_local.sh[61]: a) Remove the container using the 'docker rm -f Db2wh' command.
    [77411.166785] start_dashDB_local.sh[61]: b) Remove the image using the 'docker rmi <image>' command.
    [77411.167205] start_dashDB_local.sh[61]: c) Delete the contents of the mounted host volume specified in the docker run command
    [77411.167543] start_dashDB_local.sh[61]: (e.g. docker run ... -v <host volume>:/mnt/bludata0)
    [77411.167867] start_dashDB_local.sh[61]: Note: THIS WILL RESULT IN DATA LOSS
    [77411.168262] start_dashDB_local.sh[61]: d) Redeploy the image.
    [77411.168596] start_dashDB_local.sh[61]: Note: Db2wh is an example of a container name. Use the container name
    [77411.168924] start_dashDB_local.sh[61]: that you specified for the docker run command.
    [77411.183934] start_dashDB_local.sh[61]: If the same failure occurs, contact IBM Service.
    [77411.808600] start_dashDB_local.sh[61]: Running 'Docker storage driver' test...
    [77412.187839] start_dashDB_local.sh[61]: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    [77412.204916] start_dashDB_local.sh[61]: FATAL RUNTIME ERROR DETECTED
    [77412.221751] start_dashDB_local.sh[61]: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    [77412.232391] start_dashDB_local.sh[61]: Dumping system configuration details to help diagnose the problem
    [77412.745356] start_dashDB_local.sh[61]: Running 'Docker storage driver' test...
    [77415.048436] start_dashDB_local.sh[61]: Generation of diagnostic information complete; stopping deployment of container immediately



    docker exec -it Db2wh bash
    /var/log/Db2wh_local.log

    [2019-05-21 05:35:25,056] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: update dbm cfg using keystore_type PKCS12
    [2019-05-21 05:35:25,195] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
    [2019-05-21 05:35:25,207] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: successfully.
    [2019-05-21 05:35:25,219] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: SQL1362W One or more of the parameters submitted for immediate modification
    [2019-05-21 05:35:25,229] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: were not changed dynamically. Client changes will not be effective until the
    [2019-05-21 05:35:25,247] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: next time the application is started or the TERMINATE command has been issued.
    [2019-05-21 05:35:25,258] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG: Server changes will not be effective until the next DB2START command.
    [2019-05-21 05:35:25,275] - dashdb_db2_functions.sh:1058(setup_db2_encryption) - DEBUG:
    [2019-05-21 05:35:25,440] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd - ', mln=True, timeout=None, user='db2inst1')
    [2019-05-21 05:35:26,402] - dashdb_db2_functions.sh:31(is_db2_started) - DEBUG: Db2 is already stopped ...
    [2019-05-21 05:35:26,562] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd - ', mln=True, timeout=None, user='db2inst1')
    [2019-05-21 05:35:27,416] - dashdb_db2_functions.sh:31(is_db2_started) - DEBUG: Db2 is already stopped ...
    [2019-05-21 05:35:27,426] - dashdb_db2_functions.sh:108(db2start_or_exit) - DEBUG: db2start
    [2019-05-21 05:35:28,936] - dashdb_db2_functions.sh:109(db2start_or_exit) - DEBUG: 05/21/2019 05:35:28 0 0 SQL1026N The database manager is already active.
    [2019-05-21 05:35:28,952] - dashdb_db2_functions.sh:109(db2start_or_exit) - DEBUG: SQL1026N The database manager is already active.
    [2019-05-21 05:35:28,985] - dashdb_db2_functions.sh:134(db2start_or_exit) - DEBUG: Verifying db2 processes are fully operational
    [2019-05-21 05:35:31,129] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd -inst > /dev/null 2>&1', mln=True, timeout=300, user='db2inst1')
    [2019-05-21 05:35:34,125] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd -inst > /dev/null 2>&1', mln=True, timeout=300, user='db2inst1')
    ........
    [2019-05-21 05:36:52,283] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd -inst > /dev/null 2>&1', mln=True, timeout=300, user='db2inst1')
    [2019-05-21 05:36:55,171] - ssh_parallel:49 - DEBUG: ssh_parallel called with arguments : Namespace(command='db2pd -inst > /dev/null 2>&1', mln=True, timeout=300, user='db2inst1')
    [2019-05-21 05:36:55,721] - dashdb_db2_functions.sh:147(db2start_or_exit) - ERROR: Starting IBM Db2 Warehouse engine failed.
    [2019-05-21 05:36:55,731] - dashDB_local_common_functions.sh:1970(deployment_failed) - ERROR: IBM Db2 Warehouse installation failed. Retry the operation by re-deploying a container.
    [2019-05-21 05:36:55,752] - dashDB_local_common_functions.sh:1971(deployment_failed) - ERROR:
    * If this is an initial deployment:
    a) Remove the container using the 'docker rm -f Db2wh' command.
    b) Remove the image using the 'docker rmi <image>' command.
    c) Delete the contents of the mounted host volume specified in the docker run command
    (e.g. docker run ... -v <host volume>:/mnt/bludata0)
    Note: THIS WILL RESULT IN DATA LOSS
    d) Redeploy the image.

    Note: Db2wh is an example of a container name. Use the container name
    that you specified for the docker run command.

    [2019-05-21 05:36:55,768] - dashDB_local_common_functions.sh:1972(deployment_failed) - ERROR: If the same failure occurs, contact IBM Service.
    [2019-05-21 05:36:56,400] - dashdb_container_tests.py:254 - INFO: Running 'Docker storage driver' test...
    [2019-05-21 05:36:56,401] - dashdb_utilities.py:331 - DEBUG: Executing: grep docker /etc/mtab
    [2019-05-21 05:36:56,411] - dashdb_utilities.py:352 - DEBUG: /dev/mapper/docker-253:2-12132559-87fa17b2190f29816dd39797e1653c54fa25ecb6ce065129cc0680ca79f5bc2f / xfs rw,seclabel,relatime,nouuid,attr2,inode64,logbsize=64k,sunit=128,swidth=128,noquota 0 0
    [2019-05-21 05:36:56,411] - dashdb_container_tests.py:743 - DEBUG: Docker Storage driver: mapper
    [2019-05-21 05:36:56,775] - dashDB_local_common_functions.sh:71(stop_immediately) - ERROR: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    [2019-05-21 05:36:56,785] - dashDB_local_common_functions.sh:72(stop_immediately) - ERROR: FATAL RUNTIME ERROR DETECTED
    [2019-05-21 05:36:56,801] - dashDB_local_common_functions.sh:74(stop_immediately) - ERROR: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    [2019-05-21 05:36:56,818] - dashDB_local_common_functions.sh:75(stop_immediately) - ERROR: Dumping system configuration details to help diagnose the problem
    [2019-05-21 05:36:57,337] - dashdb_container_tests.py:254 - INFO: Running 'Docker storage driver' test...
    [2019-05-21 05:36:57,338] - dashdb_utilities.py:331 - DEBUG: Executing: grep docker /etc/mtab
    [2019-05-21 05:36:57,349] - dashdb_utilities.py:352 - DEBUG: /dev/mapper/docker-253:2-12132559-87fa17b2190f29816dd39797e1653c54fa25ecb6ce065129cc0680ca79f5bc2f / xfs rw,seclabel,relatime,nouuid,attr2,inode64,logbsize=64k,sunit=128,swidth=128,noquota 0 0
    [2019-05-21 05:36:57,349] - dashdb_container_tests.py:743 - DEBUG: Docker Storage driver: mapper
    [2019-05-21 05:36:59,631] - dashDB_local_common_functions.sh:79(stop_immediately) - ERROR: Generation of diagnostic information complete; stopping deployment of container immediately

    ------------------------------
    HIDEO HAGIWARA
    ------------------------------