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.

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