Child pages
  • Developing Against DB2
Skip to end of metadata
Go to start of metadata

Step-by-step guide

  1. docker pull ibmcom/db2express-c:
  2. docker run --name db2 -v ~/work/openidm:/openidm -it -p 50000:50000 -e DB2INST1_PASSWORD=db2inst1 -e LICENSE=accept ibmcom/db2express-c: bash
  3. Once inside container:
        $ su - db2inst1
        $ db2start
        $ db2 create database dopenidm
        $ db2 -i -tf /openidm/openidm-samples/repo-config/src/main/resources/db2/scripts/openidm.sql

  4. Configure IDM to point to the DB2 repo pointing to localhost:50000

  5. Update your username and password in datasource.jdbc-default.json to be db2inst1 (same value for both username and password)

Running explain

    $ db2expln -d openidm -g -t -q “…query here…”