DB2 Personal Developer Edition and Spatial Extender

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 19 Jul 2006 21:49 GMT

To DB2 Personal Developer Edition GIS users:

How do I acquire a spatial extender license key for the DB2 PDE? I
expected to be able to use it right out of the box.

Brad

Reply to this Message

Knut Stolze - 20 Jul 2006 08:14 GMT

> To DB2 Personal Developer Edition GIS users:
>
> How do I acquire a spatial extender license key for the DB2 PDE? I
> expected to be able to use it right out of the box.

Known issue. I'll ask how that is handled and get back to you.

One option for you may be to use the DB2 Express-C edition.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Mark A - 20 Jul 2006 09:11 GMT

> Known issue. I'll ask how that is handled and get back to you.
>
> One option for you may be to use the DB2 Express-C edition.

I don't believe that DB2 Express-C edition supports any of the extenders
(but not 100% sure about spatial).

Reply to this Message

Knut Stolze - 20 Jul 2006 12:15 GMT

>> To DB2 Personal Developer Edition GIS users:
>>
>> How do I acquire a spatial extender license key for the DB2 PDE? I
>> expected to be able to use it right out of the box.
>
> Known issue. I'll ask how that is handled and get back to you.

I got some answers...

You can simply download the DB2 Spatial Extender for DB2 Express package
from the SE website and install that package on a PDE system. You will
find that package under the "DB2 Spatial Extender Trial Download" link in
the lower right corner of this site:
http://www-306.ibm.com/software/data/spatial/
(Don't ask why the link carries the word "Trial"; nobody seems to know
that ;-))

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Brad - 21 Jul 2006 15:19 GMT

Knut,

Thanks, this idea worked. It gave me some build compatibility errors
during the install, but I was at least able to create a spatial column
in a test table.

I'm going to try to import some example shape files (if there is an
import utility) and look at them with the ESRI ArcExplorer for DB2.

>From the little bit that I"ve tried of DB2, it looks like a pretty good

database. We used to steer people away from DB2 in favor of SQL Server
and Oracle which are well supported by ESRI and other GIS systems. If
I can get some ESRI stuff ported to work on it easily, DB2 could become
a decent option.

Brad

> >> To DB2 Personal Developer Edition GIS users:
> >>
[quoted text clipped - 17 lines]
> DB2 Information Integration Development
> IBM Germany

Reply to this Message

Knut Stolze - 21 Jul 2006 16:03 GMT

> Thanks, this idea worked. It gave me some build compatibility errors
> during the install, but I was at least able to create a spatial column
> in a test table.
>
> I'm going to try to import some example shape files (if there is an
> import utility) and look at them with the ESRI ArcExplorer for DB2.

You'll find the spatial import in the DB2 Control Center or you can use the
"db2se" CLP.

As for ESRI, make sure that the tables you use do have a column named
SE_ROW_ID of type INT. That's what the -idColumn option is for in the
db2se CLP. Otherwise, ArcExplorer may not show you the spatial column.

p.s: There is also a newsgroup dedicated to the Spatial Extender:
news://news.software.ibm.com/ibm.software.db2.udb.spatial
It's a low-traffic group.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Knut Stolze - 20 Jul 2006 19:10 GMT

> To DB2 Personal Developer Edition GIS users:
>
> How do I acquire a spatial extender license key for the DB2 PDE? I
> expected to be able to use it right out of the box.

Actually, you should be able to do so:
http://www-306.ibm.com/software/data/db2/udb/edition-pde.html

That brings us to the question which error message you saw and what did you
do to trigger it.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Brad - 21 Jul 2006 15:11 GMT

> > To DB2 Personal Developer Edition GIS users:
> >
[quoted text clipped - 6 lines]
> That brings us to the question which error message you saw and what did you
> do to trigger it.

The following steps produce the request for license key:

1 Download free DB2 personal developer edition (with licensed to
spatial extender advertised to be included here:
http://www-306.ibm.com/software/data/db2/udb/edition-pde.html)
2 Install free DB2 PDE
3 Start control center
4 Create and start the database (i.e. GISTEST)
5 Right click on the database name
6 select spatial extender/enable

Get following message:

The product "DB2 Spatial Extender" does not have a valid license key
installed and the evaluation period has expired. Functions specific to
this product are not enabled.

Explanation:

A valid license key could not be found and the evaluation period has
expired.

User Response:

Install a license key for the fully entitled version of the product.
You can obtain a license key for the product by contacting your IBM
representative or authorized dealer.

> --
> Knut Stolze
> DB2 Information Integration Development
> IBM Germany

Reply to this Message

Knut Stolze - 21 Jul 2006 15:17 GMT

>> > To DB2 Personal Developer Edition GIS users:
>> >
[quoted text clipped - 13 lines]
> http://www-306.ibm.com/software/data/db2/udb/edition-pde.html)
> 2 Install free DB2 PDE

Have you chosen to install the extender?
I don't know the PDE install routine. But I would expect that you can
select/deselect the extender during the install.

> 3 Start control center
> 4 Create and start the database (i.e. GISTEST)
[quoted text clipped - 6 lines]
> installed and the evaluation period has expired. Functions specific to
> this product are not enabled.

What's the output of "db2licm -l"?

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Brad - 21 Jul 2006 15:28 GMT

> >> > To DB2 Personal Developer Edition GIS users:
> >> >
[quoted text clipped - 17 lines]
> I don't know the PDE install routine. But I would expect that you can
> select/deselect the extender during the install.

I don't remember seeing an option to install it and I don't know if DB2
keeps any installation logs. (complete newbie here, I only know Oracle
and SQL Server so I don't have an equivalence matrix built in my head
yet))

> > 3 Start control center
> > 4 Create and start the database (i.e. GISTEST)
[quoted text clipped - 8 lines]
>
> What's the output of "db2licm -l"?

I used your other suggestion of installing the package separately, so
now the db2licm -l produces the expected result. I think I'd have to
uninstall the PDE and "do over" to track down what specificly happens.
I may try that on my home PC, but it is running XP home edition, so I
don't know if it will cause any problems.

Product Name = "DB2 Personal Edition"
Product Identifier = "DB2PE"
Version Information = "8.2"
Expiry Date = "Permanent"
Annotation = ""
Other information = ""

Product Name = "DB2 Spatial Extender"
Product Identifier = "DB2GSE"
Version Information = "8.2"
Expiry Date = "Permanent"
Geodetic Extender = "Disabled"
Annotation = ""
Other information = ""

> --
> Knut Stolze
> DB2 Information Integration Development
> IBM Germany

Reply to this Message

Knut Stolze - 21 Jul 2006 16:05 GMT

> Product Name = "DB2 Personal Edition"
> Product Identifier = "DB2PE"
[quoted text clipped - 10 lines]
> Annotation = ""
> Other information = ""

The license is there all right. So you shouldn't have gotten the error
message. But given that things do work now, I don't know if you would like
to track this down any further.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Pierre Saint-Jacques - 22 Jul 2006 05:17 GMT

PMFJI, if you download the PDE that's the only thing you get. Downloading
is a piece by piece option. PDE, Connect, Spatial, and son and on.
At least that's what I've experienced in V7 and V8, I haven't done V9 yet.
Regards, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>
>> >> > To DB2 Personal Developer Edition GIS users:
[quoted text clipped - 63 lines]
>> DB2 Information Integration Development
>> IBM Germany

Reply to this Message