Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  DB2 Docker Image not initializing

    Posted 07/06/20 09:51 AM
    Greetings,

    I'm trying to create a DB2 Docker Image using the following command:

    docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=MyPassword -e DBNAME=testdb -e PERSISTENT_HOME=false ibmcom/db2

    But the startup process is getting stuck at this step (I've let it run for >30 minutes, but didn't try letting it run for hours):

    DB2 State : Operable

    DB2 has not been started

    Starting DB2...

    07/06/2020 11:28:39 0 0 SQL1063N DB2START processing was successful.

    SQL1063N DB2START processing was successful.

    (*) User chose to create testdb database

    (*) Creating database testdb ...

    I'm using Docker Desktop for Windows 10, version 2.2.0.5 Stable (I also tried with the most recent stable one, 2.3.x, but I've read somewhere that it could lead to some problems so I downgraded). I also tried removing the PERSISTENT_HOME parameter and adding a -v option, but it's still not working.

    If I stop the container and restart it again, it's also not working and is getting apparently stuck at some point (will edit the post if I end stopping and restarting the container).

    Any idea about why this might not work? All help is appreciated, and feel free to ask for more details/clarifications.

    Best regards,

    Sergio B.



    ------------------------------
    Sergio Baamonde
    ------------------------------

    #Db2


  • 2.  RE: DB2 Docker Image not initializing

    Posted 07/07/20 03:07 PM
    I could never get it to work on Windows with the '-v' option and had better success not having it create the database.

    This is what I used:
    docker run -itd --name geotools-db2 –-restart unless-stopped --privileged=true -p 50050:50000 -e LICENSE=accept -e PERSISTENT_HOME=false -e DB2INST1_PASSWORD=<choose an instance password> ibmcom/db2


    ------------------------------
    David Adler
    ------------------------------