Db2

 View Only

  • 1.  Failing DB2 precheck for Ubuntu install

    Posted Fri February 12, 2021 10:54 AM
    I am trying to install DB2 for non-root on an Ubuntu Docker image.  I posted previously about trying to run the ibmcom/db2 cloud images as non-root, but this doesn't seem possible after further investigation.  My next approach is to download and install the IBM DB2 Community edition (v11.5.5_linuxx64_server_dec.tar.gz) on an Ubuntu 20.04 server image.  I'm getting a number of pre-req failures that I'm not sure how to resolve.  Hoping someone else has resolved these and can share the solution.

    After starting with the Ubuntu 20.04 image I ran the following install/updates:
    • apt-get update -y
    • apt update && apt upgrade -y
    • apt-get install -y lib32stdc++6
    • apt-get install -y libaio-dev
    • apt-get install -y libstdc++5 libstdc++6
    • ln -s /usr/lib/x86_64-linux-gnu/libpam.so.0 /lib/libpam.so
    These resolved some of the pre-check failures with the latest results, below.  I was following the resolution on a post from last year (https://blog.dbplatz.com/how-to-install-db2-11/), but some of these packages don't seem to be readily available.  Any help is much appreciated.

    Thanks


    root@e203a786119b:/tmp/db2/server_dec# ./db2prereqcheck -v 11.5.5.0

    ==========================================================================

    Fri Feb 12 15:13:44 2021

    Checking prerequisites for DB2 installation. Version "11.5.5.0". Operating system "Linux"

       

    Validating "Linux distribution " ...

       Required minimum "UBUNTU" version: "16.04"

       Actual version: "20.04"

       Requirement matched.

       

    Validating "kernel level " ...

       Required minimum operating system kernel level: "3.10.0".

       Actual operating system kernel level: "4.19.121".

       Requirement matched.

       

    Validating "ipcmni_extend kernel parameter " ...

       WARNING : Requirement not matched.

    ERROR:

       The 'strings' utility that is used to detect prerequisite libraries

       is not present on this system.  Please use your package or software

       manager to install the GNU Binary Utilities.
       

    Validating "C++ Library version " ...

       Required minimum C++ library: "libstdc++.so.6"

       Standard C++ library is located in the following directory: "/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.28".

    sh: 1: /usr/bin/file: not found

    DBT3512W  The db2prereqcheck utility failed to determine the currently-installed version of the C++ standard library, libstdc++.

       Requirement matched.
       

    Validating "libaio.so version " ...

    DBT3553I  The db2prereqcheck utility successfully loaded the libaio.so.1 file.

       Requirement matched.

       
    Validating "libnuma.so version " ...

    DBT3552E  The db2prereqcheck utility failed to open the libaio.so.1 file. Command output: "libnuma.so.1: cannot open shared object file: No such file or directory".

    DBT3609E  The db2prereqcheck utility could not find the library file libnuma.so.1.

       ERROR : Requirement not matched.
       

    Validating "/lib/i386-linux-gnu/libpam.so*" ...

       DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/i386-linux-gnu/libpam.so*".

       WARNING : Requirement not matched.

    Requirement not matched for DB2 database "Server" . Version: "11.5.5.0".

    Summary of prerequisites that are not met on the current system:

       DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/i386-linux-gnu/libpam.so*".


    DBT3609E  The db2prereqcheck utility could not find the library file libnuma.so.1.



    ------------------------------
    Jim Creasman
    ------------------------------

    #Db2


  • 2.  RE: Failing DB2 precheck for Ubuntu install

    Posted Mon February 15, 2021 08:31 AM
    Ubuntu 20.04 is not a supported distribution for Db2 11.5.5.0 - 18.04 is the newest supported version of Ubuntu, so you may want to start with that version of the Ubuntu container.

    You'll want to installed the libnuma1, libaio1, file and binutils packages to take care of most of the requirements.  You can likely ignore the 32-bit prereqs unless you're planning to install 32-bit binaries in your container that will talk to Db2.


    ------------------------------
    Ian Bjorhovde
    XTIVIA
    Phoenix AZ
    ------------------------------

    Original Message


  • 3.  RE: Failing DB2 precheck for Ubuntu install

    Posted Mon February 15, 2021 10:15 AM

    Hello Jim,

    Looking at the Operating system requirements for Db2 11.5.5 for Linux

    System requirements for IBM Db2 for Linux, UNIX, and Windows

    Ubuntu 20.04 is not supported yet is my understanding

    I hope this helps

    Brian



    ------------------------------
    Brian Walker
    ------------------------------

    Original Message


  • 4.  RE: Failing DB2 precheck for Ubuntu install

    Posted Mon February 15, 2021 11:37 AM
    Ian and Brian, thanks for the info.  I should have mentioned in my original post that I first tried the install using an Ubuntu 18.04 image, then tried 16.04 and went to 20.04 on the most recent attempt.  I got the same pre-check failures, more or less, on all three attempts.  ​​​I wondered about the 32-bit support.  I don't need that but was adding the dependencies in hopes the pre-check would pass.  I assume there is an option to skip/ignore the pre-check step though my preference is to resolve these if possible.

    Jim

    ------------------------------
    Jim Creasman
    ------------------------------

    Original Message


  • 5.  RE: Failing DB2 precheck for Ubuntu install

    Posted Mon February 15, 2021 04:08 PM
    Hello Jim,
    To be honest , I've never tried installed DB2 11.X on Ubuntu systems . I've only install Db2 11.X on Redhat , and it always requires these 32 -bit Library files
    below as well as the 64.bit version of libstd++ and pam .

    yum install libstdc++.i686 -y
yum install pam.i686 -y

    I would typical would get warnings - like DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "xxxxxxx/libpam.so*" if
     pam.i686 is not installed. Similar to your problem you have described  .

    Brian

    ------------------------------
    Brian Walker
    ------------------------------

    Original Message


  • 6.  RE: Failing DB2 precheck for Ubuntu install

    Posted Fri February 19, 2021 11:05 AM
    Edited by System Test Fri January 20, 2023 04:13 PM
    Thanks for your help.  After some effort I was able to install and configure DB2 on the system as non-root (Ubuntu 18.04).  The installation steps required the following pre-req packages:

    apt-get update -y \
    && apt update && apt upgrade -y \
    && apt-get install -y libnuma1 \
    && apt-get install -y libaio1 \
    && apt-get install -y file \
    && apt-get install -y binutils \
    && apt-get install -y lib32stdc++6 \
    && apt-get install -y libxml2

    Jim

    ------------------------------
    Jim Creasman
    ------------------------------

    Original Message