Friday May 04, 2012

Migrating DB2 z/OS to Oracle Database

I have been receiving many requests for information on migrating IBM z/OS DB2 databases to Oracle so I thought this would be a great topic.
Third Party Tool Solutions
1.Ispirer- Ispirer - I have worked with there tool before and it is solid. They offer services as well.

Third Party SI Providers (with their own tools)
1.Prac Trans - Prac Trans - I have worked a lot with this company. They have both internal tools to migrate db2 z/OS and very skilled mainframe DB2 resources.

Oracle Solutions
A. Oracle ART Tuxedo Workbench - Oracle ART Workbench
Note: This costs minimum of $80K for two developer licenses.
Solution is disk to disk based.
B. Oracle Warehouse Builder - Free Oracle database ETL tool. You would use JDBC as listed here:
OWB
OWB supports importing of COBOL copybooks where DB2 tables are often defined. NOTE: JDBC connection to mainframe DB2 can be slow.
Solution can be disk to Oracle DB or DB2 to Oracle (stream based).
C. Oracle DRDA Gateway - Connect to DB2 on mainframe from Oracle and use Select statements to migrate (nothing to install on mainframe) Oracle DRDA Gateway
Solutions is stream based/disk less.
D. Oracle Data Integrator - No DB2 Knowledge built for DB2 mainframe but one could be developed.

Thursday Mar 15, 2012

Running applications in the cloud not designed for the cloud

The question of what to do with applications that were written for the mainframe or client/server based applications that do not fit into a shared service model of the cloud has come up a lot in the last few weeks. This is something that is addressed in chapter 8 of the Migrating to the Cloud book. The bottom line is: The issue you face with moving client/server applications to the cloud via rehosting is “where will the applications run?” Currently, your applications are installed on client PC machines or other thick client devices; the Apple iPhone is in the thick client category as you actually download an application that runs on your iPhone; the application now needs to be hosted on a central server accessible through the Web. A handful of products from Oracle and third parties are available for hosting client/server applications in the cloud. Third-party solutions include Citrix XenApp (formerly Citrix WinFrame Server, Citrix MetaFrame Server, and Citrix Presentation Server) and VMware Server. Oracle solutions include Oracle Virtual Server, Oracle Tuxedo, and Oracle Exalogic. Oracle Tuxedo is the leading open systems transaction processor (TP). It supports both COBOL and C/C++ applications, as well as Ruby and Python. Oracle Tuxedo can run on Oracle Exalogic to provide you both the application runtime environment (Tuxedo) and the cloud hardware infrastructure (Exalogic). Oracle Tuxedo can also be deployed on Oracle Virtual Server for a virtualized cloud environment. We will discuss Oracle Virtual Server and Oracle Exalogic in detail in the “Target Hardware and Software Stack Options” section later in this chapter. [Begin WARNING] A client/server application cannot just be moved to a virtual server and be considered cloud-ready. The application is now accessible by many users, so it must be multiuser and multithreaded. Oracle Tuxedo and Oracle WebLogic Server are both multiuser and multithreaded. A single-user C, C++, or Java application can be made multiuser by running this application in Oracle Tuxedo or Oracle WebLogic Server as these application server containers are multiuser and multithreaded. When using Oracle Virtual Server, it needs to be placed into a grid middle tier environment. This environment could consistent of a cluster of commodity hardware components with a load balancer in front of the configuration for managing load balancing (multithreading) and multiuser connections. This virtual server grid can then run hundreds of images of the same application so that the application can service hundreds or thousands of users. [End WARNING]
About

Migrating legacy client/server and mainframe technologies to the Oracle cloud.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today