Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DB2-Express C Column Based Tables
110 views
Skip to first unread message
Jorge Sierra
Nov 2, 2017, 1:26:52 PM11/2/17
to
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
Nov 5, 2017, 9:37:34 AM11/5/17
to
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
Jorge Sierra wrote:
> Can I create a column organized table using DB Express-C ?
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
Nov 5, 2017, 10:42:47 AM11/5/17
to
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
jstu...@attglobal.net
==================
Lennart Jonsson
Nov 5, 2017, 11:13:24 AM11/5/17
to
On 2017-11-05 15:37, Troels Arvin wrote:
[...]
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
[...]
> 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,
> 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.
>
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
Nov 5, 2017, 11:50:18 AM11/5/17
to
while; I knew they had a developer's edition but didn't realize they had
dropped the Express-C.
Lennart Jonsson
Nov 5, 2017, 12:20:45 PM11/5/17
to
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
[...]
> 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.
>
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
Nov 6, 2017, 3:19:38 PM11/6/17
to
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.
> 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:
>
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
Nov 7, 2017, 3:58:25 PM11/7/17
to
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.
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.
0 new messages