Wednesday Jul 11, 2012

Migrating blog entries

Moving blog entries from Oracle blog to Blogger was easy as Oracle blog has an export facility. You can find out more here: Migrating blog entries

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 18, 2012

Mainframe modernization - Getting it to work

Interesting read on a very old (1950s) Medicaid system that the State of NC is struggling to modernize. The new language for the modern system is COBOL. This is causing some 'heads to turn':
State of NC modernization to COBOL

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 18, 2012

Cloud Defined for grade school kids

Cloud Defined

"Cloud computing is the next stage in the Internet's evolution, providing the means through which everything — from computing power to computing infrastructure, applications, business processes to personal collaboration — can be delivered to you as a service wherever and whenever you need."

"When I can get access to all my files on all my different computers when I am at the coffee shop".

"Internet-based applications"

"Shared computer resources that can be accessed from anywhere, created by end users, be expanded and deleted as needed, and paid for as by how much you use (or free).

Example Cloud (consumer) Applications

1. Youtube -

2. Flickr -

3. Apple iCloud

4. Facetime

5. Zoho Writer -

6. Google, GMail -,

7. Skype -

8. MapMyRide -

9. Dropbox -

10. Blogs -

11. Twitter -!/migrating2cloud

12. LinkedIn -

13. Gaming

14. Gmail contacts -

What is migrating to the Cloud

Moving applications and/or information for local devices (iPads, PCs, laptops, smart phones, cell phones etc) to a location that is accessible through the internet.

Examples include:

1. Moving games that can only be played on a Wii, iPad etc. to allow them to be played by players all over the world.

2. Moving word processing applications like Microsoft Word to a browser environment like or Google Docs.

3. Moving all of you friends contact information from an address book, cell phone storage to Google contacts.

4. Moving you calendar from a daily calendar to Google contacts.

5. Moving your dairy from the 'book under your clothes in your dresser' to

Example Cloud (enterprise) Applications

1. -

2. Amazon Web Services -

3. Terremark -

Cloud Questions

1. What happened when the Internet/cloud went down ?

2. How can you continue to edit documents when the cloud is 'off line' ?

3. How can a file be shared with someone when the cloud is 'off line' ?

4. What are some ways to interact with someone (without video) using the cloud ?

5. What are some ways to share files and photos using the Cloud ?

6. How do you currently use cloud applications ?

7. How do you see yourself using the cloud after this session ?

8. What are some ways to interact with someone using video ?

9. How can you inexpensively interact with someone internationally using the c

Tuesday May 15, 2012

AWS Elastic Cloud set up

Signing, setting up and configuring EC2 cloud is easy. These instructions were very useful:
AWS EC2 Word Press Set up
Now have a Tomcat and MySQL configuration running WordPress blog:
WordPress Blog on AWS
It is so slow but I guess this is normal:
AWS EC2 Micro Instance Slow
Because it is a free micro tier virtual server

Tuesday May 08, 2012

Who is making the decison to move to the cloud ?

Some evidence to support the business community and financial organization are deciding on when to move to the cloud:
Cloud migration decisions

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.

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!

Saturday Apr 21, 2012

Data migration testing - Oracle Flashback Database makes life easier

Whether it is unit, QA, system or development testing using Oracle Flashback database can reduce time and make the process easier
Oracle Flashback for testing on OTN

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

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


« June 2016