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

Tuesday May 08, 2012

Progress Divesting mainframe integration software

Will be interesting to see which company picks up Progress DataDirect Shadow product:
Shadow for sale

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.

Tuesday May 01, 2012

What makes a DB2 migration easy ?

The four key elements are:
1. COTS application - This means no application database access or database schema to migrate (assuming no database customizations)
2. No integration interfaces - There are no web service, FTP/file, COTS API or other input, output or input/output interfaces.
3. No ETL / batch processing - The is no batch processing or ETL jobs (Oracle Data Integrator, Informatica, IBM DataStage etc.) that are outside the COTS application.
4. No data to migrate - Really ? Yes, all the data is transient. It is part of a print server, real time data capture or caching system.
This may seem like it does not happen. However, I just encountered a set of applications run by a major corporation that has all four elements!

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

Monday Oct 31, 2011

Win a copy of Migrating to the Cloud - follow me on twitter

Win a copy of this book. All you need to do is starting following me on Twitter Tom Laszewski
After two weeks, I will pick two twitter follows. These two follows will receive a free copy of this book:
Migrating to the Cloud

Friday Oct 14, 2011

Win a free Cloud Book - Just follow me on Twitter

Win a copy of this book. All you need to do is starting following me on Twitter Tom Laszewski
After two weeks, I will pick two twitter follows. These two follows will receive a free copy of this book:
Information Integration, Data Migration and Consolidation

Tuesday May 24, 2011

Migrating DB2, Sybase, SQL Server to Oracle Exadata and the cloud

Customers and partners that are migrating from non-Oracle database platforms to the Oracle 'cloud in-a-box' solutions(Exadata) often ask: 'What is the most difficult aspect of the migration?' Is it the processors, applications, application middleware, storage, management software, database, network or something else. The answer is really...it depends. I always hated that answer but it does depend on: 1. Is your network already built to handle a high amount of traffic (high bandwidth) and GB+. 2. How much database logic does your system have. Are there a lot of stored procedures? 3. What is the application built in? Can the language easily be moved to the cloud? 4. Do you want to virtualize the application and use Oracle VM? 5. Does your storage or processors need to upgraded? All these components need to be considered. So, it does depend. More on this soon.
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