• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

This community can have members from outside your organization. DB2 Performance Tuning

  • Log in to participate

▼ Tags

▼ Similar Entries

Compiling with the D...

Blog: COBOL Cafe
DavidHT 0700000V0U
Updated
0 people like thisLikes 0
No CommentsComments 0

Accessing different ...

Blog: QMF Blog
QMFDevelopment 310000NG5J
Updated
0 people like thisLikes 0
No CommentsComments 0

REORG Performance Im...

Blog: Db2 for z/OS ...
ealameida 310002GWAR
Updated
0 people like thisLikes 0
No CommentsComments 0

Why the storage grou...

Blog: Thoughts from...
db2scope 310002R9XW
Updated
0 people like thisLikes 0
No CommentsComments 0

Unable to set DB2COM...

Blog: Thoughts from...
db2scope 310002R9XW
Updated
0 people like thisLikes 0
CommentsComments 1

▼ Similar Ideas

使用Flashcopy Image Co...

Ideation Blog: 主机知刊
tianna 310001QCY5
Updated
Votes 2 No CommentsComments 0

▼ Archive

  • January 2018
  • December 2017
  • October 2017
  • August 2017
  • July 2017
  • April 2015
  • March 2015
  • January 2015
  • September 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011

▼ Blog Authors

DB2 Performance Tuning

View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.) Entry list

DB2 Compatible with Oracle

DaveBeulke 2700023WUN | | Tags:  db2 vs. oracle | 5,102 Views

Another great feature that is in the new Version 9.7 of DB2 is its new compatibility with Oracle. This compatibility takes many forms within the database such as understanding operational syntax, stored procedures keyword syntax and improved operational concurrency that I covered in this DB2 Performance blog.

The DB2 compatibility with Oracle was developed because many clients are migrating from Oracle to DB2 for its improved DB2 performance, lower licensing costs, ease of use and lower total cost of ownership (TCO). All of these factors are very compelling given the current economic times for cost savings, consolidation of servers and lower CPU and energy costs of processing within DB2 as compared to other DBMSs.

DB2 Handles Oracle’s Non-Standard Names

Many of the operational aspects of standard databases such as the data definition language (DDL), data manipulation language (DML) and structured query language (SQL) and data control language (DCL) are standard across databases such as SQL Server Oracle and DB2 Family. Over the years Oracle has called parts of these DDL, DML and DCL, non-ISO standard names, to perform operations. DB2 has added these unique Oracle non-standard operational keywords to its lexicon of syntax to perform these operational activities. The most popular is the Oracle TRUNCATE statement that is used everywhere to clear the contents of a table.

DB2 and Oracle Stored Procedures Compatibility

Another major item is stored procedures compatibility because they are utilized everywhere. Again with all the standard programming languages such as Java C++ C# and others, over the years the syntax was controlled by the ISO and other standards committees. The various DBMS vendors took liberties with their stored procedure languages do perform certain processes. Again DB2 has added these Oracle syntax items so that any developer that is familiar with Oracle will be able to quickly and effectively code for any of these DBMSs. This one feature is critical for many companies because all companies have multiple different DBMS vendors and have a programming staff that needs to write stored procedures on all of them.

Oracle to DB2 Migration Success

I recently worked with a client during the DB2 Version 9.7 Cobra program and found that the syntax for both the operational aspects and the stored procedures is about 95% there for general conversions from Oracle to DB2. Working with the dedicated client staff, some of my consultant associates and the IBM Cobra people, we were able to migrate a vendor product from Oracle to DB2 Cobra and then take the DB2 code from the Linux, UNIX and Windows platform and run the application on DB2 for z/OS environment. Given these Oracle to DB2 compatibilities, the client is positioning to leverage the lowest TCO in the industry of DB2 on z/OS with a vendor and their solution. This is remarkable because they didn’t even understand the mainframe concepts only three months ago.

Another Oracle to DB2 migration project done by a friend of mine was completed in only three days, so the conversion work can be done very quickly and you can become the next hero lowering your company’s total costs within IT. Migrate to DB2 today and save your company money, it might even save your job or your coworker’s job.

_______________________________________________________

Dave Beulke is an internationally recognized DB2 consultant, DB2 training and DB2 education instructor.Dave helps his clients improve their strategic direction, dramatically improve DB2 performance and reduce their CPU demand, saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments. Search for more of Dave Beulke’s DB2 Performance blogs on DeveloperWorks and at www.davebeulke.com.
  • Add a Comment Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry
Notify Other People
notification

Send Email Notification

+

Quarantine this entry

deleteEntry
duplicateEntry

Mark as Duplicate

  • Previous Entry
  • Main
  • Next Entry
Feed for Blog Entries | Feed for Blog Comments | Feed for Comments for this Entry