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)

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
jstucklex@attglobal.net
==================

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

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)

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)

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
jstucklex@attglobal.net
==================

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

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)

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)

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)