Saturday Jun 30, 2012

IBM DB2 AIX RISC to Oracle Linux Sun x86

Mentioned RISC to x86 migrations a couple blogs ago and now there is a new white paper out by Oracle on just this topic. The white paper goes into detail on the Oracle Linux and Database installation. It also shows how to use the free Oracle SQL Developer tool to migrate the data:
Migrating from IBM DB2 AIX to Oracle Linux Sun x86

Monday Jun 11, 2012

Unidata and RDB migrations to Oracle

Have a couple of unique migrations that don't come along to often. They are Unidata and RDB migrations. The top three things that make these migration more challenging are:
1. No automated data migration tools - Because these migration don't happen that often, there are no tools in the market place to automated the data migration.
2. Application is tied to database - The application needs to be re-architected/re-engineered. Unidata Basic and COBOL for RDB. TSRI can migrate Basic to Java and PL/SQL. Transoft can migrate DEC COBOL to Java.
3. New client hardware potentially involved - Many Unidata and RDB based systems use 'green screens' as the front end. These are character based screens that will run on very old dumb terminals such as: Wyse and DEC 5250 terminals. The user interface can be replicated in a web browser but many times these old terminals do not support web browsers.

Tuesday May 22, 2012

The COBOL Brain Drain

Cover Story in this edition of Computerworld:
COBOL Brain Drain
Some notable things from article:
1. 48% of companies still use a lot of COBOL. The highest language usage beating even Java!
2. COBOL is being used in 53% of cases for new applications.
3. Move off mainframe / COBOL is not happening any time soon (this is my interpretation) as the article mentions this a couple times 5-10 years people will start
to retire...which means more like 10-15 years.
4. Thought this was funny but sad. US government had IBM look at a System/36 environment to see if should be migrated off this system. IBM concluded it would
be to complicated and costly. This is like hiring Microsoft to see if you should move from Window/SQL Server to Linux/Oracle.

Wednesday May 16, 2012

RISC to x86 migrations - Or CISC to RISC

Migrating from RISC based systems to x86 (CISC based systems) is another type of cloud migration along with application, database, and mainframe z/OS migrations. However, the steps, best
practices, process, methodology, and tools used are the same. The components of the current RISC based architecture that need to be migrated remain the same:
1. On line application
2. Batch application
3. Integration Infrastructure
4. BI and reporting
5. ETL processing
7. Operating System
Note on OS migration: Although an operating system migration is often assumed (UNIX to Windows/Linux) in a RISC to x86 migrations, this does not necessarily need to be the case as Solaris and HP-UX (announced) run on x86.
It may also be the case you are already running Linux on your RISC system so there is no need to migrate the OS. However, you will probably be upgrading to a
newer release of Linux.
8. Operating System scripts and tools
9. Application, network, database and operating system management and monitoring products and tools
10. Other infrastructure software such as DR, replication servers, gateways, back up and recovery ....
11. Hardware refresh - Of course, you will need to purchase, install, configure and test the x86 based hardware platform. This is a great opportunity to consider hardware infrastructure that is
better suited to the cloud such as blades (Dell, CISCO UCS, Sun/Oracle) or engineered systems (Exadata and Exalogic).
Ultimately the question is how long will it take, what are all the activities involved, and how much will it cost. The answer to these questions is based more on the OS migration that is being done
then the move from RISC to x86. Will the application language or 4GL product run on Linux/Windows? What is the impact of moving the database from one OS to another ? (this should be minimal as all major relational databases run on x86). The biggest impact (for the application migration) could be Unix specific KSH or CSH scripts. You may also be running management, monitoring, or older job scheduling tools that
only run on UNIX/RISC.
As you can see, nothing is different here from what I have blogged about regarding mainframe, client/server, and application cloud migrations.
Intel has a comprehensive RISC migration white paper here:
RISC Migration

Monday May 14, 2012

The market for CICS COBOL mainframe applications

Most interesting quote from a mainframe ISV development shop:
'No one is buying CICS COBOL applications anymore'

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

Wednesday Apr 18, 2012

IBM iSeries Migrations - Interesting facts on iSeries

I am working with a major corporation that has a number of iSeries machines that are mostly running AIX and Redhat Linux. This is interesting as I would think there is a premium for running
applications and databases on a hardware platform that has minmal processing power and is optimized for a different OS (i5/OS). This lead me to do some research on where iSeries and i5/OS is headed.
Interesting facts found on an iSeries blog:
"First, some statistics. According to IBM's own internal research, some 80 percent of shops have one or two OS/400 or i5/OS systems; this means that 20 percent have more than three machines in their shop. Moreover, IBM believes that 85 percent of the machines installed at OS/400 and i5/OS shops have only a single processor core in them; this again implies that only 15 percent have multicore boxes." There are 1/2 million iSeries machines installed. Seems like many of these could be run on cheap x86 hardware platforms.
First, some statistics. According to IBM's own internal research, some 80 percent of shops have one or two OS/400 or i5/OS systems; this means that 20 percent have more than three machines in their
shop. Moreover, IBM believes that 85 percent of the machines installed at OS/400 and i5/OS shops have only a single processor core in them; this again implies that only 15 percent have multicore

Thursday Apr 05, 2012

Dell - Consolidating migration market place ?

First acquisition was re-hosting and now re-architecture:
Dell acquires Make Technologies

Wednesday Apr 04, 2012

Dell getting into platform migration space

Dell has a large service organization with its acquisition of Perot Systems a few years back. It now has expertise in getting companies off a legacy IBM mainframe systems:
Dell acquires Clerity

Monday Nov 28, 2011

A heterogeneous world

Interesting comment: 'is really recognizing that the world is heterogeneous'....
For the last twenty years...or more

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


« July 2016