considerations about migrating db2 from aix to z/os

Zhe Yang

considerations about migrating db2 from aix to z/os
HI LIST:

Environment: z/OS 1.7 / DB2 v8



on my shop, fund database(db2) is on AIX platform and the application is
written by JAVA on Websphere.

With the growing volume of transactions, database server pressure is also
growing.

From stability, throughput considerations£¬now we consider move database
from AIX to z/OS .

Therefore, I would like to ask a few issues or any redbook can offer
something about migration db2 from AIX to z/OS?

1) Can this database migration solve the problem ? (take advantage of i/o
throughput on mainframe)

2) if so, which we needs to consider, ? (SQL syntax? DRDA Overhead£¿batch
job processing method? etc..)

3) and what's the difference about db2 between AIX and z/OS? Do we need to
modify our application source?

4) we consider build a data-sharing environment, is JDBC TYPE 4 support
member routing or workload balance and work well on WAS of AIX?



thanks in advance.





_____


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: considerations about migrating db2 from aix to z/os
(in response to Zhe Yang)
In v8, there are not a lot of differences from an application point of view between DB2 z/OS and DB2 UDB .

I did a proof-of-concept migration of a WebSphere application earlier this year. The migration was from DB2 V8 z/OS to V8 on windows.

It only took me 6 hours to get the application running from the moment I started creating the database until the moment the first calculation was done in the application.



Basically, if you want to do a proof-of-concept to see if you have to make application changes you have to do the following steps:

1. Migrate database structure. I used the “replication centre wizard” tool which is part of the standard UDB administration tools.
2. Load the data. I used “load from cursor”, I generated the load statements by quering the DB2 catalog.
3. Change the jdbc connections in WebSphere. Then start the application.



To answer your questions:

1) I understand you have a i/o problem(?). If the mainframe uses the same storage servers as the AIX box does, then migrating will probably not solve your problem. I assume all the tuning options already have been tried?

2) There are still some syntax/data type differences in V8. If I were you I would try a quick proof-of-concept to see if and what changes you have to make to the application. DRDA overhead will not change since you already use drda and go through tcp/ip (type 4 driver). Scheduling batch jobs does not change because the application and it’s location does not change.

3) Depends (see above). Also, if you want to take advantage of, for instance, wlm workload priorities, you have to make changes.

4) The current (v9) type 4 jdbc driver support connection concentration and sysplex workload balancing. I don’t know for sure if that’s also the case for V8

In V7 you had to put a DB2 connect gateway server between the type 4 application and the DB2 z/OS.



If you have any more questions, feel free to ask…

Groeten,
Bart

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of ??
Sent: Wednesday, January 02, 2008 6:17 AM
To: [login to unmask email]
Subject: [DB2-L] considerations about migrating db2 from aix to z/os



HI LIST:

Environment: z/OS 1.7 / DB2 v8



on my shop, fund database(db2) is on AIX platform and the application is written by JAVA on Websphere.

With the growing volume of transactions, database server pressure is also growing.

From stability, throughput considerations,now we consider move database from AIX to z/OS .

Therefore, I would like to ask a few issues or any redbook can offer something about migration db2 from AIX to z/OS?

1) Can this database migration solve the problem ? (take advantage of i/o throughput on mainframe)

2) if so, which we needs to consider, ? (SQL syntax? DRDA Overhead?batch job processing method? etc..)

3) and what's the difference about db2 between AIX and z/OS? Do we need to modify our application source?

4) we consider build a data-sharing environment, is JDBC TYPE 4 support member routing or workload balance and work well on WAS of AIX?



thanks in advance.





________________________________

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.
-----------------------------------------------------------------