JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe

Maureen

JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe
Hello,

I work on a Z9 mainframe that runs z/os 1.4 and DB2 V7. We have a peer
group on AIX that has a JDBC Type 4 driver and would like to communicate
with DB2 V7 on the mainframe. DB2 does not exist on the AIX platform.

We have the Distributed Data Facility address space configured and running
on the mainframe and it has been for a long while. It is running with
TCP/IP.

Could anyone give me the jump start that we need? There was a mention that
we might need to licensce DB2 Connect on the AIX platform, is this true or
can the JDBC Type 4 driver do the job?

Any thoughts are welcome.

Thanks,

Maureen Preston
The Ohio State University Medical Center
[login to unmask email]

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Infodemic B.V. Douwe van Sluis

Re: JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe
(in response to Maureen)
Maureen,

The type 4 DB2 for z/OS Universal JDBC Driver can do the job.
But...it seems that you need a licence for DB2 Connect. No need to install
any DB2 Connect stuff. But...you could give it a try without, just to see if
it works. You need to copy some files from z/OS to AIX, see my previous post
on this one. Have fun.

Vriendelijke groet,
Douwe van Sluis, Infodemic B.V.


-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Maureen
Verzonden: donderdag 11 januari 2007 19:13
Aan: [login to unmask email]
Onderwerp: [DB2-L] JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe

Hello,

I work on a Z9 mainframe that runs z/os 1.4 and DB2 V7. We have a peer
group on AIX that has a JDBC Type 4 driver and would like to communicate
with DB2 V7 on the mainframe. DB2 does not exist on the AIX platform.

We have the Distributed Data Facility address space configured and running
on the mainframe and it has been for a long while. It is running with
TCP/IP.

Could anyone give me the jump start that we need? There was a mention that
we might need to licensce DB2 Connect on the AIX platform, is this true or
can the JDBC Type 4 driver do the job?

Any thoughts are welcome.

Thanks,

Maureen Preston
The Ohio State University Medical Center
[login to unmask email]

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John McKown

Re: JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe
(in response to Infodemic B.V. Douwe van Sluis)
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of Douwe van Sluis,
> Infodemic B.V.
> Sent: Thursday, January 11, 2007 2:29 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] JDBC Type 4 driver on AIX goig to DB2 V7
> Mainframe
>
>
> Maureen,
>
> The type 4 DB2 for z/OS Universal JDBC Driver can do the job.
> But...it seems that you need a licence for DB2 Connect. No
> need to install
> any DB2 Connect stuff. But...you could give it a try without,
> just to see if
> it works. You need to copy some files from z/OS to AIX, see
> my previous post
> on this one. Have fun.
>
> Vriendelijke groet,
> Douwe van Sluis, Infodemic B.V.

IIRC, someone here once said that it was against IBM licensing to copy
any of the Java jar files from z/OS to AIX (or Linux or Windows or ...)
even though they do work. Now, a company may get away with doing a
one-off test to see. But not to continue to use them would likely cause
grief.

--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology

The information contained in this e-mail message may be privileged
and/or confidential. It is for intended addressee(s) only. If you are
not the intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication is
strictly prohibited and could, in certain circumstances, be a criminal
offense. If you have received this e-mail in error, please notify the
sender by reply and delete this message without copying or disclosing
it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Marcel Harleman

Re: JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe
(in response to John McKown)
Hi,

A few follow-up questions on my behalf then.

Is IBM currently the only supplier of a JDBC type 4 driver or are
there others?
And if there are do they use a licensing strategy similar to IBM's
(i.e. more or less separately)? Or do they only license the driver as
part of a bigger software package? Or don't they license the JDBC
driver at all?

Anyone?

Marcel.

>> -----Original Message-----
>> From: DB2 Data Base Discussion List
>> [mailto:[login to unmask email] On Behalf Of Douwe van Sluis,
>> Infodemic B.V.
>> Sent: Thursday, January 11, 2007 2:29 PM
>> To: [login to unmask email]
>> Subject: Re: [DB2-L] JDBC Type 4 driver on AIX goig to DB2 V7
>> Mainframe
>>
>>
>> Maureen,
>>
>> The type 4 DB2 for z/OS Universal JDBC Driver can do the job.
>> But...it seems that you need a licence for DB2 Connect. No
>> need to install
>> any DB2 Connect stuff. But...you could give it a try without,
>> just to see if
>> it works. You need to copy some files from z/OS to AIX, see
>> my previous post
>> on this one. Have fun.
>>
>> Vriendelijke groet,
>> Douwe van Sluis, Infodemic B.V.
>
>IIRC, someone here once said that it was against IBM licensing to copy
>any of the Java jar files from z/OS to AIX (or Linux or Windows or ...)
>even though they do work. Now, a company may get away with doing a
>one-off test to see. But not to continue to use them would likely cause
>grief.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Brian Bear

Re: JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe
(in response to Marcel Harleman)
datadirect.com



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
Sent: Friday, January 12, 2007 1:11 AM
To: [login to unmask email]
Subject: Re: [DB2-L] JDBC Type 4 driver on AIX goig to DB2 V7 Mainframe






Hi,

A few follow-up questions on my behalf then.

Is IBM currently the only supplier of a JDBC type 4 driver or are there
others?
And if there are do they use a licensing strategy similar to IBM's (i.e.
more or less separately)? Or do they only license the driver as part of
a bigger software package? Or don't they license the JDBC driver at all?

Anyone?

Marcel.

>> -----Original Message-----
>> From: DB2 Data Base Discussion List
>> [mailto:[login to unmask email] On Behalf Of Douwe van Sluis, Infodemic
>> B.V.
>> Sent: Thursday, January 11, 2007 2:29 PM
>> To: [login to unmask email]
>> Subject: Re: [DB2-L] JDBC Type 4 driver on AIX goig to DB2 V7
>> Mainframe
>>
>>
>> Maureen,
>>
>> The type 4 DB2 for z/OS Universal JDBC Driver can do the job.
>> But...it seems that you need a licence for DB2 Connect. No need to
>> install any DB2 Connect stuff. But...you could give it a try without,

>> just to see if it works. You need to copy some files from z/OS to
>> AIX, see my previous post on this one. Have fun.
>>
>> Vriendelijke groet,
>> Douwe van Sluis, Infodemic B.V.
>
>IIRC, someone here once said that it was against IBM licensing to copy
>any of the Java jar files from z/OS to AIX (or Linux or Windows or ...)

>even though they do work. Now, a company may get away with doing a
>one-off test to see. But not to continue to use them would likely cause

>grief.

------------------------------------------------------------------------
---------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

*****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm