答复: [DB2-L] considerations about migrating db2 from aix to z/os

Zhe Yang

答复: [DB2-L] considerations about migrating db2 from aix to z/os
Thanks Bart for your reply.



In order to resolve the large concurrent transaction volume(about 4000 concurrent connections) with the DB server on AIX, we consider move DB server to the mainframe to take advantage of Z9’s new features (ZIIP), and new storage devices.



Some questions:

1) The request from WAS(AIX V5) to access the db2(ANOTHER BOX) by using jdbc universal driver type 4.

Is this DRDA request?

If so, can I Say Once I use the WEBSPHERE connecting to the database by using jdbc(TYPE 4), that’s the DRDA request. No matter where db server locate, even if, WAS and DB server in the same box, Right?

2) Do we need to configure WAS to use DRDA? how the WAS determine when to use DRDA or the decision is made by JDBC??

3) IN DB2 V8 ON Z/OS , DRDA REQUEST will automatically using multi-row fetch ,right? Is there any problem about it?

I mean one DRDA fetch multi-row returned.



Thanks



Yang Zhe


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

[login to unmask email]

Re: 答复: [DB2-L] consider ations about migrating db2 from aix to z/os
(in response to Zhe Yang)
1) Yes.

That’s correct. A type 4 connection is always using drda, via a tcp/ip connection, to connect to DB2, even when WAS and DB2 are on the same box. These threads will benefit from the zIIP processor you’re planning to use.



2) You can use normal datasource connections to connect to DB2. Both type 2 and type 4 use drda to connect to the DB2 system on the other box. You are already using the drda protocol to connect to DB2 in your current environment.



3) That’s correct for a remote application that uses block-fetching. For a good explanation you can read the redbook “DB2 UDB for zOS Version 8 Performance Topics”, chapter 7.2



Maybe it’s a good idea to also consider migrating the application to DB2 9 for z/OS instead of DB2 V8 for z/OS.

Groeten,
Bart

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of ??
Sent: Thursday, January 03, 2008 3:53 PM
To: [login to unmask email]
Subject: [DB2-L] 答复: [DB2-L] considerations about migrating db2 from aix to z/os



Thanks Bart for your reply.



In order to resolve the large concurrent transaction volume(about 4000 concurrent connections) with the DB server on AIX, we consider move DB server to the mainframe to take advantage of Z9’s new features (ZIIP), and new storage devices.



Some questions:

1) The request from WAS(AIX V5) to access the db2(ANOTHER BOX) by using jdbc universal driver type 4.

Is this DRDA request?

If so, can I Say Once I use the WEBSPHERE connecting to the database by using jdbc(TYPE 4), that’s the DRDA request. No matter where db server locate, even if, WAS and DB server in the same box, Right?

2) Do we need to configure WAS to use DRDA? how the WAS determine when to use DRDA or the decision is made by JDBC??

3) IN DB2 V8 ON Z/OS , DRDA REQUEST will automatically using multi-row fetch ,right? Is there any problem about it?

I mean one DRDA fetch multi-row returned.



Thanks



Yang Zhe


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information < http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------