Db2

Db2

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

 View Only
  • 1.  Docker Community Edition and columnar database

    Posted Mon January 04, 2021 11:21 AM


    I would like to use the Docker Community Edition Db2 with column-organized tables. Is this supported?


    ------------------------------
    Pablo Schor
    ------------------------------

    #Db2


  • 2.  RE: Docker Community Edition and columnar database

    Posted Tue January 05, 2021 05:30 AM
    Hi,
    as I know in the community edition there are all features - like BLU - available

    see Number 5: Create an environment variables file, .env_list, for your Db2 Community Edition image:
    https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.db2u_openshift.doc/doc/
    • BLU sets BLU Acceleration for the Db2 instance to enabled (true) or disabled (false)


    ------------------------------
    Jürgen Jost
    DB2 DBA (LUW / zOS)
    ------------------------------



  • 3.  RE: Docker Community Edition and columnar database

    Posted Wed January 06, 2021 09:42 AM
    I implemented BLU in Community Edition in Docker and worked perfectly  





  • 4.  RE: Docker Community Edition and columnar database

    Posted Thu January 07, 2021 03:33 AM
    very good -
    a friend is db2 developer - is there a setup / sample tables available to start with BLU?

    ------------------------------
    Jürgen Jost
    DB2 DBA (LUW / zOS)
    ------------------------------



  • 5.  RE: Docker Community Edition and columnar database

    Posted Thu January 07, 2021 05:02 AM
    You just need to set this in the container command line:

    db2 update dbm cfg using INTRA_PARALLEL ON

    ------------------------------
    Pablo Schor
    ------------------------------



  • 6.  RE: Docker Community Edition and columnar database

    Posted Tue January 05, 2021 02:43 PM
    It is supported, see for example:

    https://hub.docker.com/r/ibmcom/db2

    • BLU can be set to true to enable BLU Acceleration for instance


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