DB2 Spatial Extender & DB2 for z/OS

DB2 Spatial Extender & DB2 for z/OS

Post by Walter SCHNEIDE » Fri, 07 Feb 2003 20:55:32



Hello!

can the DB2 Spatial Extender be used together with DB2 for z/OS anyways...?

I've read on the IBM Pages, that DB2 Spatial Extender runs on WIN/UX
Platforms (but not z/OS Unix System Services) only, but it is not clear to
me, if it can be connected to a DB2 for z/OS system by means of the DB2
Connect product or not.

Any advice will be appreciated!

Walter SCHNEIDER.

 
 
 

DB2 Spatial Extender & DB2 for z/OS

Post by Knut Stolz » Fri, 07 Feb 2003 21:10:36


Walter SCHNEIDER wrote on Thursday 06 February 2003 12:55:

Quote:> Hello!

> can the DB2 Spatial Extender be used together with DB2 for z/OS anyways...?

> I've read on the IBM Pages, that DB2 Spatial Extender runs on WIN/UX
> Platforms (but not z/OS Unix System Services) only, but it is not clear to
> me, if it can be connected to a DB2 for z/OS system by means of the DB2
> Connect product or not.

You cannot store spatial data using the extender's model on DB2 for zOS.  You
could, however, convert the data to BLOBs or so and stori the BLOBs on the
mainframe and then access it through a federated server and convrt it on the
fly.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

 
 
 

DB2 Spatial Extender & DB2 for z/OS

Post by Walter SCHNEIDE » Fri, 07 Feb 2003 21:56:42


If I got you right, this means that we need a DB2 UDB Instance (+Spatial
Extender) anyways on WIN/UX to establish the federated DB...
Thanks hewever for your immediate reply - it will be a great support for our
further decisions!

Regards
Walter SCHNEIDER
Telekom Austria AG InformationsTechnologie



Quote:> Walter SCHNEIDER wrote on Thursday 06 February 2003 12:55:

> > Hello!

> > can the DB2 Spatial Extender be used together with DB2 for z/OS
anyways...?

> > I've read on the IBM Pages, that DB2 Spatial Extender runs on WIN/UX
> > Platforms (but not z/OS Unix System Services) only, but it is not clear
to
> > me, if it can be connected to a DB2 for z/OS system by means of the DB2
> > Connect product or not.

> You cannot store spatial data using the extender's model on DB2 for zOS.
You
> could, however, convert the data to BLOBs or so and stori the BLOBs on the
> mainframe and then access it through a federated server and convrt it on
the
> fly.

> --
> Knut Stolze
> Information Integration
> IBM Germany / University of Jena

 
 
 

1. Probs with DB2/DB2 spatial extender

Hello again,

first of all thanks to your quick response. Meanwhile, i tried to use the
extender with the db2-clp. Everything works fine, so i think that the
control center hasnt been set up properly or that it comprises a kind of
bug. To lose no further time, i decided to do my researches via the clp.
This leads to a new question: Can anybody tell me how to specify a spatial
reference system from the clp? In the guide, i only found an explanation of
the necessary steps with the control center. Or can anyone point me to an
URL where this is explained in detail?
(I want to specify a spatial reference system with normal GPS-format
(WGS-84, lat/lon-based), scale factor 10^5).

Again, thanks to all,

Greets,
Achim

2. Oracle 8.0.5 starter DB

3. Integrating XML with DB2 XML Extender and DB2 Text Extender, SG24-6130-00

4. Comments from the Gallery

5. DB2 Spatial Extender Question....

6. Help!! Per. Oracle 8.0.4 won't allow install using local installer (ie latest 3.3.1.2.4 Y2K compliant one)

7. Information relating to DB2's Spatial Extender for GIS

8. Pdoxwin Corrupted Pointers

9. Db2 Spatial Extender Download

10. DB2 Spatial Extender

11. Performance of db2 spatial extender...

12. DB2 Conenct & DB2 on OS/390

13. Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT