DB2 Personal Developer Edition and Spatial Extender

[Brad]

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

[Knut Stolze]

Brad wrote:

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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mark A]

"Knut Stolze" <st****@de.ibm.comwrote in message
news:e9**********@lc03.rz.uni-jena.de...

>
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

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

[Knut Stolze]

Knut Stolze wrote:

Brad wrote:

>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 ;-))

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Knut Stolze]

Brad wrote:

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...ition-pde.html

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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Brad]

Knut Stolze wrote:

Brad wrote:

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...ition-pde.html

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...ition-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

[Knut Stolze]

Brad wrote:

>
Knut Stolze wrote:

>Brad wrote:

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...ition-pde.html

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...ition-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)
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.

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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Brad]

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
Knut Stolze wrote:

Knut Stolze wrote:

Brad wrote:

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 ;-))

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Brad]

Knut Stolze wrote:

Brad wrote:

Knut Stolze wrote:

Brad wrote:

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...ition-pde.html

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...ition-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.

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)
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.

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

[Knut Stolze]

Brad wrote:

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.sof...b2.udb.spatial
It's a low-traffic group.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Knut Stolze]

Brad wrote:

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 = ""

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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Pierre Saint-Jacques]

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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Brad" <br**********@gmail.coma écrit dans le message de news:
11**********************@m73g2000cwd.googlegroups. com...

>
Knut Stolze wrote:

>Brad wrote:

>
Knut Stolze wrote:
Brad wrote:

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...ition-pde.html

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...ition-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.

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)
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.

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