Discussion:
DB2-Express C Column Based Tables
(too old to reply)
Jorge Sierra
2017-11-02 17:26:50 UTC
Permalink
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
Troels Arvin
2017-11-05 14:37:31 UTC
Permalink
Hello,
Post by Jorge Sierra
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
Jerry Stuckle
2017-11-05 15:42:42 UTC
Permalink
Post by Troels Arvin
Hello,
Post by Jorge Sierra
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
***@attglobal.net
==================
Lennart Jonsson
2017-11-05 16:13:20 UTC
Permalink
On 2017-11-05 15:37, Troels Arvin wrote:
[...]
Post by Troels Arvin
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
Jerry Stuckle
2017-11-05 16:50:14 UTC
Permalink
Post by Lennart Jonsson
[...]
Post by Troels Arvin
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
***@attglobal.net
==================
Lennart Jonsson
2017-11-05 17:20:41 UTC
Permalink
On 2017-11-05 17:50, Jerry Stuckle wrote:

[...]
Post by Jerry Stuckle
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
Ian
2017-11-06 20:19:36 UTC
Permalink
Post by Lennart Jonsson
[...]
Post by Jerry Stuckle
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
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
Jorge Sierra
2017-11-07 20:58:23 UTC
Permalink
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.
Loading...