Connection from z/os to DB2 on Unix

Horacio Villa

Connection from z/os to DB2 on Unix
Hi, we are dealing with a prospect who has applications running on z/OS (no DB2) who wants to access data on DB2 on Unix.Are you aware of any documentation explaining if this is possible, and how?Installing a DB2 on z/OS just to act as DB2 Connect is not an option, but maybe on USS.Kind regards,Horacio Villa

Jørn Thyssen

RE: Connection from z/os to DB2 on Unix
(in response to Horacio Villa)

Hi,

You can connect to Db2 over DRDA using DDF.

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Tony Saul

Connection from z/os to DB2 on Unix
(in response to Horacio Villa)
Horacio,Do you have CICS? If so, you could look at Websphere Liberty that can perform JDBC type 4 connections to non-mainframe (and mainframe DB2 z/OS if you couldn't install DB2 locally).
 Regards, Tony

From: Horacio Villa <[login to unmask email]>
To: [login to unmask email]
Sent: Saturday, 28 October 2017, 4:21
Subject: [DB2-L] - Connection from z/os to DB2 on Unix

Hi, we are dealing with a prospect who has applications running on z/OS (no DB2) who wants to access data on DB2 on Unix.Are you aware of any documentation explaining if this is possible, and how?Installing a DB2 on z/OS just to act as DB2 Connect is not an option, but maybe on USS.Kind regards,Horacio Villa 

Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email] a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

J&#248;rn Thyssen

[AD] RE: Connection from z/os to DB2 on Unix
(in response to Jørn Thyssen)

Sorry, I now see that I misread your question: you do not have Db2 !

As mentioned you can connect to Db2 directly from a java program: CICS Liberty, stand-alone Liberty, and stand-alone Java.

If you want to access from COBOL you can also look at the new IBM Data Virtualization Manager.

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Javier Estrada Benavides

RE: [AD] RE: Connection from z/os to DB2 on Unix
(in response to Jørn Thyssen)

Hi:

I agree that using Java as a stand alone is the simplest way, though perhaps your application needs to read a lot of data from that Db2 on Unix or read entire tables (meaning, your application on z/OS is not a transactional application and it's batch), we can only guess from this side. Maybe if that's applicable to you, you can set up an NFS server so that files created in your Unix environment (from Db2 unloads or scripts) can be read from your z/OS applications as local datasets.

Hope that helps 

 

Regards,

Javier Estrada Benavides, Mexico

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Charles Brown

Connection from z/os to DB2 on Unix
(in response to Tony Saul)
Hello Horacio Villa,
Have you contacted your IBM account rep who I believe is extremely familiar with your environment for solutions on how connect z/os applications with db2 LUW. The productive question here is -- what are these applications? CICS, IMS? What type of processing is in question-- meaning batch or transactional? For batch processing, I'd highly recommend Datastage. For transaction processing I would recommend Q-Replication
Hope this helps.

Charles
NZ DBA

Sent from my iPad

> On Oct 28, 2017, at 6:16 PM, Tony Saul <[login to unmask email]> wrote:
>
> Horacio Villa

Karen Wilkins

RE: Connection from z/os to DB2 on Unix - [AD]
(in response to Horacio Villa)

Hi Horacio,

You might want to have a look at a new IBM tool - Data Virtualization Manager for z/OS. It runs as a started task on z/OS and allows to you to access data across a large number of sources, both on and off the mainframe.

The announcement letter is here:

http://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_sm/m/877/ENUS5698-DVM/index.html&lang=en&request_locale=en#Header_13

I hope that helps.

Kind Regards,

Karen

Peter Backlund

[LUW] Need help with Developer Community Edition
(in response to Karen Wilkins)
I won't start with "dear esteemed list" , but rather

Hello everyone,

As you may know, I am now retired, spending winters in Spain (and summers in Sweden).
Well, winter and winter, today we have 25 degrees in the air and the Mediterranean.
That is centigrade - for you Americans it is about 80 - lovely.

Although being retired from DB2 (or Db2) for z/OS I am still enjoying DB2.
I therefore decided to play with the DB2 Developer Community Edition (DB2 DCE).

I have a Lenovo Yoga laptop, 64-bit and Windows 10 pro.
I downloaded the DB2 DCE and am trying to install it...
My first problem is after specifying the passwords I get the following
Please ensure ports 11080, 11081, 11082 and 50000 are open.
and that's where I am stuck.
I have checked the ports and everything seems OK, but I must be missing something.
Any help would be greatly appreciated.

Best regards,

Peter


--

+--------------------------------+---------------------------------+
| Peter G Backlund | E-mail: [login to unmask email] |
+--------------------------------+---------------------------------+
| Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
+--------------------------------+---------------------------------+
| May - September | October - April |
+------------------------------------------------------------------+
| Råsundavägen 94 | Calle Alella 55, Apt 2B |
| S-169 57 SOLNA | 03185 Torrevieja |
| Sweden | Spain |
+--------------------------------+---------------------------------+
| Playing with DB2 since 1981 ... and forever! |
+------------------------------------------------------------------+

Philip Nelson

[LUW] Need help with Developer Community Edition
(in response to Peter Backlund)
Peter,

I've not had a lot of success with the Developer-C installer.

I've been working on Linux, since I don't have Windows Pro, but only one of
many install attempts have been successful (I've tried on different Linux
distributions and versions).

The one I did get installed I found took over the standard DB2 port (it
mapped your local port 50000 to port 50000 within the Docker image) which
meant that your local Db2 would not start any more.

What I do know it is only an interim solution using a local Docker
repository until the Docker images are made available on the Docker Hub /
Docker Store.

In fact you'll find that the first of these has already appeared -

https://store.docker.com/images/db2-developer-c-edition

I've had much better success following the install instructions from here
(albeit it isn't a nice graphical interface). I discovered this seems to
be better specified : it mapped a free port on your local box to the
internal port 50000.

There isn't a DSM image available on Docker Store yet, although I suspect
it won't be long. So if you are wanting DSM then you will have to
persevere with trying to get the port number mapping to work. I found it
was very "hit or miss" - but certainly if you are running a local DSM or
DB2 (which use these ports) then the Docker image install will want to take
these over. You could shut down DSM and DB2 and try again (knowing that
you are going to have to remap your local ones onto something else).

Personally, if you just want the Db2 Developer-C then I'd use the one from
Docker Store.

Phil

On 30 October 2017 at 10:38, Peter Backlund <[login to unmask email]> wrote:

> I won't start with "dear esteemed list" , but rather
>
> Hello everyone,
>
> As you may know, I am now retired, spending winters in Spain (and summers
> in Sweden).
> Well, winter and winter, today we have 25 degrees in the air and the
> Mediterranean.
> That is centigrade - for you Americans it is about 80 - lovely.
>
> Although being retired from DB2 (or Db2) for z/OS I am still enjoying DB2.
> I therefore decided to play with the DB2 Developer Community Edition (DB2
> DCE).
>
> I have a Lenovo Yoga laptop, 64-bit and Windows 10 pro.
> I downloaded the DB2 DCE and am trying to install it...
> My first problem is after specifying the passwords I get the following
>
> Please ensure ports 11080, 11081, 11082 and 50000 are open.
>
> and that's where I am stuck.
> I have checked the ports and everything seems OK, but I must be missing
> something.
> Any help would be greatly appreciated.
>
> Best regards,
>
> Peter
>
>
> --
>
> +--------------------------------+---------------------------------+
> | Peter G Backlund | E-mail: [login to unmask email] |
> +--------------------------------+---------------------------------+
> | Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
> +--------------------------------+---------------------------------+
> | May - September | October - April |
> +------------------------------------------------------------------+
> | Råsundavägen 94 https://maps.google.com/?q=R%C3%A5sundav%C3%A4gen+94&entry=gmail&source=g | Calle Alella 55, Apt 2B |
> | S-169 57 SOLNA | 03185 Torrevieja |
> | Sweden | Spain |
> +--------------------------------+---------------------------------+
> | Playing with DB2 since 1981 ... and forever! |
> +------------------------------------------------------------------+
>
>
> -----End Original Message-----
>