Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  db2 image does not work in Podman unless a volume is specified

    Posted Thu August 17, 2023 11:30 AM

    First of all, I must say how much I hated the transition from hub.docker.com to icr. You go to icr.io you are redirect to a sales page for container registry! Huh!!!

    Anyway.. I don't want to diverge that discussion from my real issue:

    if I run the image without specifying the -v for the data in Podman, it is not possible to connect to the database. and Everything works just fine in docker.

    I need just a quick DB to run my unit tests so I don't really need persistence.

    It's a bit worse to me as it does not work in MAC if I specify the -v..

    So I'm on a weird situation, that if I'm on Mac I must use docker and not map a folder, but if I'm on Linux I have to either use docker or -v to a volume.

    I am collecting scripts for my unit-tests here: 

    https://github.com/clebertsuconic/activemq-artemis/tree/more-databases/tests/database-support/scripts

    (I don't think the link will survive after a few weeks, but I will have moved it somewhere in artemis if you are reading this from a near future).



    ------------------------------
    Clebert Suconic
    ------------------------------


  • 2.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 02:56 AM

    I discovered the same phenomena yesterday on RHEL9/Fedora 38. If I don't specify -v for /database db2 does not start. I tried adding:

     -e PERSISTENT_HOME=false

    and then it seems to work. The documentation at: https://hub.docker.com/r/ibmcom/db2/ says:

     PERSISTENT_HOME is true by default, only specify to false if you are running Docker for Windows.

    which is a bit confusing



    ------------------------------
    Lennart Jonsson
    ------------------------------



  • 3.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 10:22 AM

    Thank you so much... that did the trick. It's all working now:

    It is currently sitting on this repo:

    https://github.com/clebertsuconic/activemq-artemis/tree/more-databases/tests/db-tests/scripts

    and I will be under here in a couple weeks:

    https://github.com/apache/activemq-artemis/tree/main/tests/db-tests/scripts



    ------------------------------
    Clebert Suconic
    ------------------------------



  • 4.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 10:42 AM

    Actually.. something still going on...

    it worked on mac, but it failed on Linux.

    It always work with docker.

    how can I raise an issue? there's no JIRA, nothing?



    ------------------------------
    Clebert Suconic
    ------------------------------



  • 5.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 10:51 AM
    Can you log into the container and check if db2 is running?





  • 6.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 11:10 AM

    I'm not really sure what to look for

    the project is at

    git clone https://github.com/clebertsuconic/activemq-artemis.git

    git checkout more-databases

    cd tests/db-tests/scripts

    ./start-db2.sh

    There seems to be an error message at the end with podman logs -f db2-artemis-test:

    But the fact it runs on docker and not on podman tells me that there's an issue with the image itself. I was wondering how I could raise an issue with ibm on the image. 



    ------------------------------
    Clebert Suconic
    ------------------------------



  • 7.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 11:41 AM

    annot descend any further than the above subdirectory.

    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)

      [0] 0x00007F2610E4F402 /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x24F402

      [1] 0x00007F2610E503AE ossLogSysRC + 0x8E

      [2] 0x00007F2610E426C1 /home/db2inst1/sqllib/lib64/libdb2osse.so.1 + 0x2426C1

      [3] 0x00007F261265A2A5 sqloSystemErrorHandler + 0x455

      [4] 0x00007F26125CD1B8 sqloopenp + 0x8E8

      [5] 0x00007F2613D94480 _Z21cfgExportProfileItemsP8cfgIntCBP22CFG_EXPORT_PROFITEMS_TP5sqlca + 0x1A0

      [6] 0x00007F2613D74547 cfgica + 0x1157

      [7] 0x0000000000401B1F main + 0x64F

      [8] 0x00007F260F83AD85 __libc_start_main + 0xE5

      [9] 0x0000000000401CFF db2cfexp + 0x1CFF

    2023-08-18-15.39.25.965898+000 I266487E399           LEVEL: Error

    PID     : 30204                TID : 139801515033664 PROC : db2cfexp

    INSTANCE: db2inst1             NODE : 000

    HOSTNAME: db2-artemis-test

    FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:7

    MESSAGE : Open file failed: rc = 

    DATA #1 : Hexdump, 4 bytes

    0x00007FFDE7364E64 : 0100 0F84                                  ....

    2023-08-18-15.39.25.966017+000 I266887E367           LEVEL: Error

    PID     : 30204                TID : 139801515033664 PROC : db2cfexp

    INSTANCE: db2inst1             NODE : 000

    HOSTNAME: db2-artemis-test

    FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30

    MESSAGE : File: 

    DATA #1 : String, 25 bytes

    /database/config/dbdbmcfg

    2023-08-18-15.39.25.966131+000 I267255E481           LEVEL: Warning

    PID     : 30204                TID : 139801515033664 PROC : db2cfexp

    INSTANCE: db2inst1             NODE : 000

    HOSTNAME: db2-artemis-test

    FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:253

    MESSAGE : Header:

    DATA #1 : Hexdump, 32 bytes

    0x00007FFDE7364EF0 : 2A20 2020 2020 454E 4420 2020 2020 202A    *     END      *

    0x00007FFDE7364F00 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A    **** EXPORT ****



    ------------------------------
    Clebert Suconic
    ------------------------------



  • 8.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 02:29 PM

    Actually.. it's working...

    it's just that it had a false start once.. retried it and worked.

    Thank you so much for your help



    ------------------------------
    Clebert Suconic
    ------------------------------



  • 9.  RE: db2 image does not work in Podman unless a volume is specified

    Posted Fri August 18, 2023 02:46 PM
    Thanks for the feedback. Now I wont have to investigate whether I was just lucky to get it to work��