Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for the ‘PL/SQL’ Category

Gartner: IBM DB2’s Maturing Oracle Compatibility Presents Opportunities, with some Limitations

leave a comment »

When IBM DB2 first added syntax that is compatible with Oracle Database data types, SQL, PL/SQL, scripting, and more, Gartner wrote their “first take” on the technology in IBM DB2 9.7 Shakes Up the DBMS Market With Oracle Compatibility. More than two years later, Gartner are now following up with a research report on the features. You can read the research report at: IBM DB2’s Maturing Oracle Compatibility Presents Opportunities, with some Limitations. This is not a commissioned report. It is independent research from Gartner.

Gartner: IBM DB2's Maturing Oracle Compatibility Presents Opportunities, with some Limitations


Written by Conor O'Mahony

September 19, 2011 at 9:34 am

Got Oracle Database Skills? Get DB2 Skills at No Charge…

leave a comment »

IBM has a couple of great ways for people with Oracle Database skills to easily add DB2 skills to their resumes. These are available at no charge, allowing you to add skills to your resume and become more attractive to potential employers.

  • The IBM DB2 Workshop for Oracle Professionals is a 2-day classroom-based workshop. This workshop helps people who are already familiar with Oracle Database to learn DB2. That’s correct… high-quality classroom-based training at no charge! Attendees even get to take the DB2 9 Family Fundamentals Certification Exam at no charge. We currently have workshops scheduled in Brazil, Canada, Cyprus, France, Germany, Greece, Hong Kong, Indonesia, Korea, Malaysia, Philippines, Romania, Singapore, Spain, Switzerland, Thailand, Turkey, and the United States. If your location is not listed on the workshop Web page, please check back soon as IBM frequently updates the list of classes.
  • IBM developerWorks is a tremendous resource. It was awarded the Forrester Groundswell Award with Josh Bernoff claiming that developerWorks “is perhaps the largest and most effective customer community we’ve seen.” Well, developerWorks has a new DB2 Fundamentals for Oracle Professionals: Introduction to DB2 learning path. These learning paths are a step-by-step set of articles that help build your proficiency. There are additional learning paths available if you master the introductory one.

Written by Conor O'Mahony

June 14, 2011 at 9:55 am

IBM DB2 and Oracle Database—Amusing Video

with 3 comments

Here’s part 2 of the animation that is based on the mythical Town of DB2 and the Village of Orrible. Notice the Hex-ya Bait-ya (Exadata) reference. We hope you find it amusing…

If you didn’t already see Part 1, you can see it at reTHINK migration – Part I of II.

Written by Conor O'Mahony

February 23, 2011 at 9:51 am

Having Some Fun: IBM DB2 and Oracle Database

with one comment

Here’s a little animation that is based on the mythical Town of DB2 and the Village of Orrible. We hope you find it amusing…

Part 2 will be coming soon.

Written by Conor O'Mahony

June 1, 2010 at 12:00 pm

PL/SQL Support in DB2

leave a comment »

According to his profile on, Lewis Cunningham is an “Oracle ACE, Database Architect and self-professed database geek”. Many people know Lewis as an influential influential voice in the database world. A couple of days ago, Lewis blogged about PL/SQL Anonymous Blocks (in DB2 9.7). For those of you who are not aware, DB2 9.7—which was released a few months ago—supports the most commonly used PL/SQL syntax. In fact, PL/SQL support in DB2 is just the tip of the iceberg. The following table describes some of the new features in DB2 9.7.

Oracle Database Feature DB2 9.7 Support
Concurrency control Native support
Data types Native support
SQL dialect Native support
PL/SQL Native support
PL/SQL packages Native support
Built-in packages Native support
JDBC client with extensions Native support
SQL*Plus scripts Native support

You can get more details about these new features at DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows on the IBM developerWorks Web site.

Several hundred organizations were part of the Beta testing for these new features. We got some great feedback from them. Here is a small selection of that feedback:

DB2’s PL/SQL compatibility is excellent. We’re looking forward to integrating the current dual source code base into a single one. This will increase our development and testing productivity. In addition, SQL compatibility is significantly improved. We ran an Oracle-version program ‘as is’ on DB2, and the test result was better than we expected. The compatibility level that DB2 9.7 achieved is amazing.
—Masahiko Kudo, Works Applications (Japan)

The IBM DB2 9.7 compatibility is amazing — and there are no queries or DB2-specific code in our applications! Everything is compatible with Oracle and DB2 9.7.
—Gene Ostrovsky, VP Research and Development, ExactCost

As a migration specialist, the new DB2 9.7 PL/SQL compatibility features help Oracle users migrate to DB2 seamlessly. These features drastically reduce the time required for migration efforts and significantly lower overall costs. The custom Perl scripts and defined manual workarounds, which I previously relied on for database porting services, are now obsolete. DB2 9.7 allows native support of PL/SQL, weak typing, enhanced locking methods and a vast array of other features designed to make database migration virtually effortless.
—Axel Puerner, Puerner Unternehmensberatung

Written by Conor O'Mahony

September 15, 2009 at 9:40 am

Gartner’s First Take on DB2 9.7

leave a comment »

Gartner’s first take on DB2 9.7 makes for interesting reading. Gartner typically makes such reports available to the public for a short time before moving them behind paid subscription. Gartner’s first take on DB2 is currently available on their public site at IBM DB2 9.7 Shakes Up the DBMS Market With Oracle Compatibility.

Written by Conor O'Mahony

August 6, 2009 at 9:52 am

DB2’s New Features for Oracle Database Users

with one comment

As I’m sure you’ve heard by now, DB2 9.7 has several new features that make it easy for Oracle Database users to work with IBM DB2. They even make it easier to switch from Oracle Database to DB2:-) Today, IBM developerWorks published an article from Serge Reilau about the new Oracle Compatibility features in DB2. You can read the article at DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows. It includes information about the new concurrency features, data types, built-in functions, SQL support, PL/SQL support, script support, and more. Of course, Serge also talks about the restrictions and limitations.

Written by Conor O'Mahony

July 23, 2009 at 7:15 pm

%d bloggers like this: