Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

Using DB2Connect

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?
0
k_murli_krishna
Asked:
k_murli_krishna
  • 3
  • 3
1 Solution
 
momi_sabagCommented:
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
0
 
k_murli_krishnaAuthor Commented:
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.
0
 
k_murli_krishnaAuthor Commented:
Momi, please answer or post a link so that I can close this question.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
momi_sabagCommented:
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?
0
 
k_murli_krishnaAuthor Commented:
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.
0
 
momi_sabagCommented:
so you should use db2 connect
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now