473,846 Members | 1,975 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 Personal Developer Edition and Spatial Extender

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

Jul 19 '06 #1
11 3325
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
Jul 20 '06 #2
"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).
Jul 20 '06 #3
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
Jul 20 '06 #4
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
Jul 20 '06 #5

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
Jul 21 '06 #6
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
Jul 21 '06 #7
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
Jul 21 '06 #8

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
Jul 21 '06 #9
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
Jul 21 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2655
by: Bill S. | last post by:
We have a Sql Server 2000 Personal Edition CD that came with a system we bought with SQL Server Standard Edition and other application software. The CD sleeve does not have a CD key on the back. I suspect that someone put the CD in the wrong sleeve, but I am not sure. Does the Personal Edition CD usually come in a sleeve with the CD key on it?
1
1283
by: iconsa | last post by:
Hello, Could i start work with personal edition then move all data to enterprise edition ? i've to design and code on workgroup environment then implement to windows server 2003. Do i just cut & paste data ? TIA Pong
2
3164
by: Belinda | last post by:
Hi. I am just getting started with DB2's spatial extender and could really use some help. Pointers to good docs or examples are welcome. I am using DB2 version 8 on Sun. I have a database of genomic data and believe the spatial extender will help in querying. I have to do intersections, subtractions, proximity, etc of ranges in the chromosomes. The database and even some tables include data on all chromosomes of several species. I am...
2
2254
by: Aquila Deus | last post by:
Hi all! I just read DB2 UDE's license and found that it only restricts the use of Personal Developer Edition but not the Personal Edition. Does this mean I can use it for *any* purpose?
16
2229
by: deko | last post by:
Is there any reason, other than the distributable Access runtime, to use Office XP developer? I tried installing it on my system, but apparently I need to install/update a bunch of components - "Windows Component Update" or something... not sure I want to do this. What can I do with the Developer edition that I can't do with the Professional edition? I found this on the net, but it sounds like marketing hype:
2
2550
by: peter.prib | last post by:
Hi, I am having trouble getting DB2 to select an index I have created for a spatial location. Table definition create table gps_paf_address ( gnaf_address gnaf_address not null ,GNF_PID varchar(015) not null
1
3524
by: vasilip | last post by:
I'm testing out db2 for a project I'm starting that requires proper xml support and I can't seem to get both xml and spatial data to work well in the same table. Once having created a table containing both xml and spatial data fields I can't seem to find a way to alter the table I have created a table containing an id, xmldata field and a ST_Point If I try to drop the xml field with ALTER TABLE TEST DROP COLUMN
2
4455
by: sohail28 | last post by:
Hello, I want to Buy "SQL Server 2000 Personal Edition", from online or reseller etc., I fed up of searching for SQL Server 2000 Personal Edition, in online & in Software Market. Any one can help me from where can i get this Software package. Any URL or Company name who sells this Software. I want a original one with License No. And one more Query: Are Standard, Enterprise, Developer, Personal Edition are one & the same,
0
9879
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9725
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10640
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10330
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9477
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7877
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7050
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4111
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.