1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • DB2-Express C Column Based Tables

    From Jorge Sierra@21:1/5 to All on Thu Nov 2 10:26:50 2017
    Can I create a column organized table using DB Express-C ? 11.1.X ? 10.5?

    db2 connect to sample
    db2 "CREATE TABLE TBL1 ( A BIGINT, B TIMESTAMP) ORGANIZE BY COLUMN"


    This give an error like SQL8029N A valid license key was not found for the requested functionality

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jerry Stuckle@21:1/5 to Troels Arvin on Sun Nov 5 10:42:42 2017
    On 11/5/2017 9:37 AM, Troels Arvin wrote:
    Hello,

    Jorge Sierra wrote:
    Can I create a column organized table using DB Express-C ?

    As far as I can tell from the description of Express-C, the BLU feature
    is not available in Express-C.

    I don't quite understand IBM's reasoning regarding that. How are
    developers who are experimenting and/or trying to learn Db2 supposed to
    learn that part of Db2 it is not part of Express-C? As far as I can tell,
    BLU is only available in some very expensive editions of Db2.


    I understand completely. It is very common for free versions of
    products to have limited capabilities. And in tiered pricing, even the
    less expensive paid versions don't have all available features.

    Express-C is meant to be an entry-level version for people with limited requirements, not one to learn all of the features of DB2.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    [email protected]
    ==================

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lennart Jonsson@21:1/5 to Troels Arvin on Sun Nov 5 17:13:20 2017
    On 2017-11-05 15:37, Troels Arvin wrote:
    [...]
    I don't quite understand IBM's reasoning regarding that. How are
    developers who are experimenting and/or trying to learn Db2 supposed to
    learn that part of Db2 it is not part of Express-C? As far as I can tell,
    BLU is only available in some very expensive editions of Db2.


    Express-c is replaced with Developer-C which includes all functionality,
    but is limited to 4 cores, 16Gb memory and 100Gb data. Further
    restrictions is that it cannot be used in production, but is for
    development purposes only. You can download it the traditional way or as
    a docker container, beware that it deviates a bit from normal docker
    containers in that it starts up a gui where you can configure it.


    /Lennart

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Troels Arvin@21:1/5 to Jorge Sierra on Sun Nov 5 14:37:31 2017
    Hello,

    Jorge Sierra wrote:
    Can I create a column organized table using DB Express-C ?

    As far as I can tell from the description of Express-C, the BLU feature
    is not available in Express-C.

    I don't quite understand IBM's reasoning regarding that. How are
    developers who are experimenting and/or trying to learn Db2 supposed to
    learn that part of Db2 it is not part of Express-C? As far as I can tell,
    BLU is only available in some very expensive editions of Db2.

    --
    Regards,
    Troels Arvin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jerry Stuckle@21:1/5 to Lennart Jonsson on Sun Nov 5 11:50:14 2017
    On 11/5/2017 11:13 AM, Lennart Jonsson wrote:
    On 2017-11-05 15:37, Troels Arvin wrote:
    [...]
    I don't quite understand IBM's reasoning regarding that. How are
    developers who are experimenting and/or trying to learn Db2 supposed to
    learn that part of Db2 it is not part of Express-C? As far as I can tell,
    BLU is only available in some very expensive editions of Db2.


    Express-c is replaced with Developer-C which includes all functionality,
    but is limited to 4 cores, 16Gb memory and 100Gb data. Further
    restrictions is that it cannot be used in production, but is for
    development purposes only. You can download it the traditional way or as
    a docker container, beware that it deviates a bit from normal docker containers in that it starts up a gui where you can configure it.


    /Lennart


    IBM's dropped the Express-C edition, Lennart? I haven't checked for a
    while; I knew they had a developer's edition but didn't realize they had dropped the Express-C.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    [email protected]
    ==================

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lennart Jonsson@21:1/5 to Jerry Stuckle on Sun Nov 5 18:20:41 2017
    On 2017-11-05 17:50, Jerry Stuckle wrote:

    [...]

    IBM's dropped the Express-C edition, Lennart? I haven't checked for a
    while; I knew they had a developer's edition but didn't realize they had dropped the Express-C.


    That was my impression, but I see that express-C is still listed so
    perhaps I jumped to conclusions:

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/c0058536.html


    /Lennart

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ian@21:1/5 to Lennart Jonsson on Mon Nov 6 12:19:36 2017
    On Sunday, November 5, 2017 at 10:20:45 AM UTC-7, Lennart Jonsson wrote:
    On 2017-11-05 17:50, Jerry Stuckle wrote:

    [...]

    IBM's dropped the Express-C edition, Lennart? I haven't checked for a while; I knew they had a developer's edition but didn't realize they had dropped the Express-C.


    That was my impression, but I see that express-C is still listed so
    perhaps I jumped to conclusions:


    Express-C is not going away. From what I've heard, it will continue to be available as it has been in the past, including for production environments and even redistribution.

    In addition to the CPU and memory limits, the other key point of the Developer-C license is that it not licensed for use in production environments. So, perfect for learning the advanced features (including BLU and pureScale).


    Ian Bjorhovde

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jorge Sierra@21:1/5 to All on Tue Nov 7 12:58:23 2017
    Hey...thanks for all the replies, let me download the Developer-C and do some tests. I recall doing some Eclipse Data Studio experimentation with column oriented tables, in the past. May be it was some Developer version and not the Express-C, or a test
    ESE version. As I tested again today with 10.5 and 11.1 and the same License Restriction error occurred. Informix doesn't have column oriented tables, so I can't use it.

    By the way, making the docker version of db2 express-c, work was a lot of pain, the last thing was changing the user rights to /dev/shm to be able to create a test database.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)