Db2

 View Only
  • 1.  CREATE DATABASE hangs when vm runs on one hypervisor

    Posted Mon October 30, 2023 03:50 PM

    Hello,

    I face a very strange issues, running DB2 11.5.8.0 on Debian Buster virtualized with Proxmox.

    We have several hypervisors, several of them are AMD EPYC 7371 based and when I CREATE DATABASE on a virtual machine running on one of these everything runs smoothly.

    A new AMD EPYC 7343 hypervisor is now available, and when I migrate the exact same virtual machine on it, "CREATE DATABASE"  hangs with two db2sysc hitting 100%. In db2diag, nothing happens after "DB2SPCAT Views recreated", while the next step on the other hypervisors is "FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:2716".

    I checked the AESNI with openssl and it works fine in both contexts.

    I also tried to limit the CPU flags to the very basic set without more success.

    CREATE DATABASE is not only symptom but as it is can easily be reproduced I use it for debugging.

    I'm a bit lost here with the next steps for debugging, any help would be greatly appreciated.

    Thank you

    Patrick



    ------------------------------
    Patrick Ambuhl
    ------------------------------


  • 2.  RE: CREATE DATABASE hangs when vm runs on one hypervisor

    IBM Champion
    Posted Tue October 31, 2023 03:19 AM

    You may want to review the system requirements for running Db2. IBM provides a list of supported distributions and hypervisors. While you may be able to run in other environments, you may run in to strange issues like what you're seeing.


    Here is the report for Db2 11.5.8 Standard Edition on Linux:

    (http://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=8C80C510B6C311ECBDA1ED9610150DDC&osPlatforms=Linux&duComponentIds=S007%7CS006%7CS004%7CS005%7CS008%7CA002%7CA003%7CA001&mandatoryCapIds=183%7C25&optionalCapIds=47%7C17%7C1%7C131%7C35%7C20%7C28)



    ------------------------------
    Ian Bjorhovde
    XTIVIA
    ------------------------------



  • 3.  RE: CREATE DATABASE hangs when vm runs on one hypervisor

    IBM Champion
    Posted Wed November 01, 2023 08:23 AM

    Hi!

    As Ian stated - if you consider "production level" Db2 installation - you are strongly advised to follow and adhere to system requirements for running Db2.

    For my personal amusement I set up Debian (Debian 12) installation in Oracle Virtual Box VM and I installed Db2 V11.5.8.
    One of the red lights should grab your attention was message from db2prereqcheck:



    However - if you know Db2 prerequisites and how to address them - you may complete installation:


    As you can see - SAMPLE database was created and is accessible.

    I would suspect your virtualizer as guilty party.

    I would not run production workload on my Debian distribution in Virtual Box though.



    ------------------------------
    Jan Nelken
    ------------------------------



  • 4.  RE: CREATE DATABASE hangs when vm runs on one hypervisor

    Posted Wed November 01, 2023 10:48 AM

    Hello,

    Thanks for your answers, we tried with Ubuntu 20 on the same hypervisor and did not face the issue.

    I will follow your advice and switch to a supported OS.

    Thank a lot for your replies.

    Patrick



    ------------------------------
    Patrick Ambuhl
    ------------------------------



  • 5.  RE: CREATE DATABASE hangs when vm runs on one hypervisor

    IBM Champion
    Posted Wed November 01, 2023 10:57 AM

    I would strongly advise to switch to Supported OS (for example Ubuntu 2204 - which is LTS) under Supported virtualiser ...



    ------------------------------
    Jan Nelken
    ------------------------------