By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,496 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,496 IT Pros & Developers. It's quick & easy.

Connecting DB2/400 through iSeries Access drivers or DB2 Connect, which's more efficent?

P: n/a
Hi there,

Does somebody know the efficent way to connect DB2/400? Through iSeries
Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and
efficent?

In addition, does DB2 Connect use APPC over TCP/IP protocol? Or SNA
protocol?
Thanks in advance~

Dec 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Anyone knows?

Laurence

Dec 23 '05 #2

P: n/a
Laurence wrote:
Anyone knows?

Laurence


Most connections nowdays between either DB2 Connect client or iSeries
Access client and DB2 UDB for iSeries server are TCP/IP. You can use
APPC for DB2 Connect if you like. DB2 Connect flows DRDA datastream
while iSeries Access flows a protocol unique to iSeries.

I can't offer any comparative info about efficiency of one vs the other.
You might ask over on the comp.sys.ibm.as400.misc newsgroup, as a
number of iSeries customers follow that.

More info here about configuring for DB2 Connect (using DRDA) is in the
Distributed Database Programming book:
http://publib.boulder.ibm.com/infoce...dp/rbal102.htm

More info about using iSeries Access is in the InfoCenter:
http://publib.boulder.ibm.com/infoce...v5r3/index.jsp
Connecting to iSeries
iSeries Access
iSeries Access for Windows
Programming
Database Programming

--
Karl Hanson
Dec 23 '05 #3

P: n/a
Thanks Karl, for your reply & info.

Laurence

Dec 25 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.