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.
Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

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

More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

734 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