windowsx86db2odbcamd-processor

DB2 ODBC connection hangs


I've installed DB2 11.5.7 (and 11.5.8) on my Windows 10. I've created SAMPLE DB (using db2sampl).
When I'm trying to connect to this DB through ODBC it hangs on connection stage (I have to kill process).
It doesn't matter either connection establishing from my x86 application (C++) or from ODBC Data Source Administrator (32-bit).

Screenshot

If I launch ODBC Data Source Administrator (64-bit) - connection always success.

Some additional info of my machine:

On all other machines which I tested no any similar problems.

What I tried:

I expect success connection from ODBC 32-bit.


Solution

  • Finally found fix myself :)

    Accordingly to call stack from my C++ app and to process happened catched by ProcMon I was almost confident that hang happens inside icclib (it's by stack) and it's is a part of GSKIT.

    So I decided to search in google about some hang problem related to GSK8 and voila I find this IBM reported issue:

    IJ44774: GSKIT ISSUE WITH AMD EPYC FAMILY 25 PROCESSORS

    Error description

    Commands like mmcrcluster or mmaddnode may hang in GSKIT
    layer on AMD EPYC family 25 processors.  A particular model
    from family 25 that is known to hang in GSKIT layer is
    AMD EPYC 7343.
    

    Local fix

    Add "ICC_SHIFT=3" line in
    /usr/lpp/mmfs/lib/gsk8/Cicc/icclib/ICCSIG.txt
    file on problem nodes.
    

    ...

    Symptom:

    Admin commands hangs
    

    Platforms affected:

    Linux OS environments
    

    Functional Area affected:

    Admin Commands, gskit
    

    Path to ICCSIG.txt on Windows:

    C:\Program Files (x86)\ibm\gsk8\lib\C\icc\icclib\ICCSIG.txt