Using DB2Connect

Posted on 2008-06-16
Last Modified: 2008-06-20
1) I believe that DB2Connect is used to connect to host systems from non-host systems. Is this
correct? Is this the only way?

2) Does host systems mean only mainframes with AS/400, MVS, OS/2, OS/390 etc. as OS? Does
non-host systems mean mid-range AIX, IBM PC desktop UNIX, Solaris, Linux, laptops & palmtops?

3) What about apple-mcintosh & HP-UX? Is DB2 available and can we use DB2Connect to connect to
host systems?

4) What about the other way round from host systems to non-host ones?

5) What about non-host ones to non-host ones? Is DB2Connect optional in this case?

6) When is a DB2Connect Server/Gateway used? What is the difference with & without it?

7) What is Data Distribution Facility(DDF)? Is this mainframe specific? How does it interact with DB2Connect gateway/client?
Question by:k_murli_krishna
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 37

Accepted Solution

momi_sabag earned 200 total points
ID: 21796118
1) you are correct. it's not the only way. there are 3rd party products that also do it like HIS by microsoft. you can also use the universal jdbc driver
2) yes
3) i don't think db2 has a version for macintosh. hp-ux is not an host, so you can connect to it using a regular client
4) implement drda protocol client yourself
5) you don't need db2 connect here. non-host db2's can communicate between themselfs natively
6) db2 connect always has a server component and a client component. the server component connects to the host, the client component connects to the server component (unless you use some versions that has only servers and are only capable to connect a single non-host server to host servers for  example - personal edition)
7) ddf is the component on the mainframe db2 that is responsible for communication (inbound and outbound). it is the component that interacts with the db2 connect gateway
LVL 17

Author Comment

ID: 21796286
Thanks, momi.
4) implement drda protocol client yourself: Does that mean we need to code the entire client OR DRDA client is available to install and we need to do some fine tune coding/configuration.
Please post some good link(s) if they can help further.
LVL 17

Author Comment

ID: 21811584
Momi, please answer or post a link so that I can close this question.
AWS Certified Solutions Architect - Associate

This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.

LVL 37

Expert Comment

ID: 21815594
no drda client is available, the protocol is available and you will need to implement it, but i would not choose that solution as it is very error prone
what do you need to accomplish?
LVL 17

Author Comment

ID: 21816052
I need to suggest good approaches to migrate data from iSeries AS/400 database schema to SUSE Linux x8664 DB2. So, if control is kept on mainframes side then we need to connect from host to non-host. But AS/400 DB2 is production which is being migrated along with application migration to Linux boxes.
LVL 37

Expert Comment

ID: 21816203
so you should use db2 connect

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question