MVS DB2 tables - connecting with PC

[Bill]

A question. I'm not a programming professional, but here goes....

We have a number of large systems running in an IBM MVS evironment.
Mostly DB2 tables, with some older stuff in IMS.

We were wondering if it is possible to connect to these DB2 tables
with a PC via some sort of ODBC connection.

Anyone have experience with this??

Bill

bills52@flash.n et

[Ian]

Re: MVS DB2 tables - connecting with PC

Bill wrote:[color=blue]
> A question. I'm not a programming professional, but here goes....
>
> We have a number of large systems running in an IBM MVS evironment.
> Mostly DB2 tables, with some older stuff in IMS.
>
> We were wondering if it is possible to connect to these DB2 tables
> with a PC via some sort of ODBC connection.
>
> Anyone have experience with this??[/color]

DB2 Connect is what you're looking for. It comes in 2 flavors, "Personal
Edition," which connects desktops directly to the mainframe DB2, and
"Enterprise Edition", which is a gateway product (i.e. you install it on a
server and configure the mainframe connection in one place, and all of the
end-user PCs use the free DB2 Runtime Client to connect to the gateway).


Good luck,



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Bill]

Re: MVS DB2 tables - connecting with PC

On Sat, 06 Dec 2003 08:56:09 -0800, Ian <ianbjor@mobile audio.com>
wrote:
[color=blue]
>Bill wrote:[color=green]
>> A question. I'm not a programming professional, but here goes....
>>
>> We have a number of large systems running in an IBM MVS evironment.
>> Mostly DB2 tables, with some older stuff in IMS.
>>
>> We were wondering if it is possible to connect to these DB2 tables
>> with a PC via some sort of ODBC connection.
>>
>> Anyone have experience with this??[/color]
>
>DB2 Connect is what you're looking for. It comes in 2 flavors, "Personal
>Edition," which connects desktops directly to the mainframe DB2, and
>"Enterprise Edition", which is a gateway product (i.e. you install it on a
>server and configure the mainframe connection in one place, and all of the
>end-user PCs use the free DB2 Runtime Client to connect to the gateway).
>
>
>Good luck,
>
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----== Over 100,000 Newsgroups - 19 Different Servers! =-----[/color]
Ian

Thanks. I looked at the IBM web site. Now if i can just get the boss
to spring for the cost of some licenses...

[Mark A]

Re: MVS DB2 tables - connecting with PC

> Thanks. I looked at the IBM web site. Now if i can just get the boss[color=blue]
> to spring for the cost of some licenses...[/color]

You will also have to get your mainframe people to set up communication
parameters on MVS and DB2 if they haven't already done so.

[Bill]

Re: MVS DB2 tables - connecting with PC

On Sat, 6 Dec 2003 10:28:23 -0700, "Mark A" <ma@switchboard .net>
wrote:
[color=blue][color=green]
>> Thanks. I looked at the IBM web site. Now if i can just get the boss
>> to spring for the cost of some licenses...[/color]
>
>You will also have to get your mainframe people to set up communication
>parameters on MVS and DB2 if they haven't already done so.
>[/color]
Mark,

Thanks for the input. I think I know who I can talk to about this at
my facility.

I currently write some code using RAMIS JCL SyncSort, SAS , and QMF to
get the data or gernerate reports. on the input side, it's all
mainframe code (cobol, telon screens).

Over the past few years, we've talked repeatedly about other methods.
Particularly about some form of gui front end instead of the mainframe
screens. However, the powers in charge don't seem interested unless
you wave a solution under there noses....