DB2 for OS/390 from other platforms

Mark Tierney

DB2 for OS/390 from other platforms
Hello List,

Currently we have a Data Warehouse that is queried by Mainframe query tools.
This is considered somewhat antiquated and a little cumbersome as it
requires our clients to have special training. We are beginning to look at
querying the data from other platforms (user pc's, other databases, etc.). I
myself have only used distributed from DB2 Connect (users all on a lan, MS
Excel, MS SQLServer, etc.) in a limited fashion and from other DB2 ssid's on
MVS (or OS/390) so I am a little foggy on some requirements.

Is DB2 Connect ALWAYS REQUIRED when people are connecting from other
platforms as a middleware layer?
Does anyone know of any query products that can connect to DDF directly
without DB2 Connect?

Also if anyone could suggest a redbook or paper that may describe the
options one has, that would be great!

Any help is greatly appreciated.

Thanks, Mark



Hilton Tina

Re: DB2 for OS/390 from other platforms
(in response to Danny Creed)
I don't know how you can do it without something like DB2 Connect, but there
are alternatives to DB2 Connect. We use StarSQL from StarQuest.

-----Original Message-----
From: Tierney, Mark [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2000 4:21 PM
To: [login to unmask email]
Subject: DB2 for OS/390 from other platforms


Hello List,

Currently we have a Data Warehouse that is queried by Mainframe query tools.
This is considered somewhat antiquated and a little cumbersome as it
requires our clients to have special training. We are beginning to look at
querying the data from other platforms (user pc's, other databases, etc.). I
myself have only used distributed from DB2 Connect (users all on a lan, MS
Excel, MS SQLServer, etc.) in a limited fashion and from other DB2 ssid's on
MVS (or OS/390) so I am a little foggy on some requirements.

Is DB2 Connect ALWAYS REQUIRED when people are connecting from other
platforms as a middleware layer?
Does anyone know of any query products that can connect to DDF directly
without DB2 Connect?

Also if anyone could suggest a redbook or paper that may describe the
options one has, that would be great!

Any help is greatly appreciated.

Thanks, Mark








William Gannon

Re: DB2 for OS/390 from other platforms
(in response to Mark Tierney)
Hi Mark,

I wish I could answer your technical questions but alas I can not. As for the 'recommended documents' - the entries on my list of "Read when you get free time" ;-) are :
Distributed Relational Database Architecture Connectivity Guide (SC26-4783) and
Distributed Relational Database Cross Platform Connectivity and Applications (SG24-4311)

Hope these help

Bill G.


Tierney, Mark wrote:

> Hello List,
>
> Currently we have a Data Warehouse that is queried by Mainframe query tools.
> This is considered somewhat antiquated and a little cumbersome as it
> requires our clients to have special training. We are beginning to look at
> querying the data from other platforms (user pc's, other databases, etc.). I
> myself have only used distributed from DB2 Connect (users all on a lan, MS
> Excel, MS SQLServer, etc.) in a limited fashion and from other DB2 ssid's on
> MVS (or OS/390) so I am a little foggy on some requirements.
>
> Is DB2 Connect ALWAYS REQUIRED when people are connecting from other
> platforms as a middleware layer?
> Does anyone know of any query products that can connect to DDF directly
> without DB2 Connect?
>
> Also if anyone could suggest a redbook or paper that may describe the
> options one has, that would be great!
>
> Any help is greatly appreciated.
>
> Thanks, Mark
>
>
>



Danny Creed

Re: DB2 for OS/390 from other platforms
(in response to William Gannon)
I am sure there are other vendors that supply the client. One that used to be
quoted on the list heavy was something like StarSQL or something like that.

QMF for windows goes direct into DB2 with TCPIP and no CAE client or DB2 Connect
software is required.
Not sure about the others.

Don't know if this helps
Regards
Danny




[login to unmask email] on 01/05/2000 03:20:35 PM

Please respond to [login to unmask email]

To: [login to unmask email]
cc: (bcc: Daniel S Creed/HI/CSC)
Subject: DB2 for OS/390 from other platforms



Hello List,

Currently we have a Data Warehouse that is queried by Mainframe query tools.
This is considered somewhat antiquated and a little cumbersome as it
requires our clients to have special training. We are beginning to look at
querying the data from other platforms (user pc's, other databases, etc.). I
myself have only used distributed from DB2 Connect (users all on a lan, MS
Excel, MS SQLServer, etc.) in a limited fashion and from other DB2 ssid's on
MVS (or OS/390) so I am a little foggy on some requirements.

Is DB2 Connect ALWAYS REQUIRED when people are connecting from other
platforms as a middleware layer?
Does anyone know of any query products that can connect to DDF directly
without DB2 Connect?

Also if anyone could suggest a redbook or paper that may describe the
options one has, that would be great!

Any help is greatly appreciated.

Thanks, Mark








Roger Miller

Re: DB2 for OS/390 from other platforms
(in response to Hilton Tina)
QMF for Windows implements the DRDA requester directly, so there is no
need for DB2 Connect. We've found that DB2 Connect has been doing
very well.

Roger Miller



Thomas E. Faglon

Re: DB2 for OS/390 from other platforms
(in response to Roger Miller)
Try qmf for windows
http://www.rocketsoftware.com/qmf/
Tom



Dennis P Bennett

Re: DB2 for OS/390 from other platforms
(in response to Thomas E. Faglon)
Dennis P [login to unmask email]
01/06/2000 12:16 PM

Mark,

NEON Systems, where I work, has a product called Shadow Direct which will
allow clients
to directly access DB2 data and stored procedures.

Shadow Direct consists of two parts, a client-side driver (available for
Windows, Unix, Linux, OS/2)
and an OS390-MVS-based server. Shadow Direct uses either the ODBC or JDBC
API and accesses DB2
through the Call Attach Facility. The product performs very well and can
scale to over tens of
thousands of users. There is no need for any gateway servers when
connecting to the mainframe.

Because the Shadow Direct components exist on both the client and the
mainframe side,
it can provide more comprehensive end-to-end monitoring, diagnostic, and
control capabilities
than can a purely outboard architecture. Built-in debugging, tracing and
performance monitors allow
application developers to more quickly develop and debug their own code.
All security can be controlled through any SAF-compliant security product
(RACF, ACF/2, Top Secret).

In addition to DB2, Shadow Direct can also access IMS (TM and DB), CICS,
VSAM, and
Adabas.

If you want some more information you can reply to me via email, look at
our web site at http://www.neonsys.com, or call 1-800-505-NEON (6366).

Thanks,
Dennis Bennett
Systems Consultant
NEON Systems
(NASDAQ: NESY)
[login to unmask email]