Oracle to DB2 Conversion Guide: Compatibility Made Easy

In this IBM® Redbooks® publication, we describe the new DB2 Oracle Database compatibility features. The latest version of DB2® includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, and more. These features dramatically improve the ease of developing applications that run on both DB2 and Oracle, and simplify the process of moving from Oracle to DB2.

In addition, IBM now provides rich tooling to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by way of the Optim™ Data Studio tool suite.

This Oracle to DB2 migration guide describes new technology, best practices for moving to DB2, and how to handle some common scenarios. It is now dramatically easier than ever to move to DB2 and experience the benefits of the IBM industry leading database, which offers a lower cost of ownership, ease of use, storage savings, industry leading performance, and superior customer support.

Within six weeks of DB2 9.7 becoming generally available, scores of companies had already reported very high compatibility between the code they developed for Oracle and what they were experiencing with DB2 9.7. These companies reported out-of-the-box compatibility rates between 90%-100% (measured by the percentage of statements that required modification), with typical compatibility in the high 90s. These statistics come from dozens of early adopters who shared their code and their experiences with IBM.

Chapter 1. Introduction
Chapter 2. Language compatibility features
Chapter 3. Enablement tools
Chapter 4. Enablement scenario
Chapter 5. Application conversion
Appendix A. Terminology mapping
Appendix B. Data types
Appendix C. Built-in packages
Appendix D. DB2 OCI sample program
Appendix E. Test cases
Appendix F. Additional material

Publish Date
06 November 2009

Rating:
(based on 5 reviews)

Rate this book

Author(s)

Whei-Jen Chen is a Project Leader at the International Technical Support Organization, San Jose Center. She has extensive experience in application development, database design and modeling, and DB2 system administration. Whei-Jen is an IBM Certified Solutions Expert in Database Administration and Application Development, as well as an IBM Certified IT Specialist.

• Whei-Jen Chen

Kenneth Chen is an Executive IT Specialist with Information Management Partner technologies based at the IBM DB2 Toronto Lab. He is recognized for his technical expertise and experiences across the Information Management portfolio products. His leading role in application integration and enablement from competitive databases with IBM Business Partners and clients worldwide has contributed to many success stories in the field. In addition, he collaborates closely with DB2 development on external requirements to continue responding to the database application development community.

• Kenneth Chen

Patrick Dantressangle is a Senior Software Engineer for DB2, based at the IBM Hursley Lab in UK. His work focuses on all aspects of migrations from other RDBMSs to DB2 in EMEA. Patrick works closely with customers and Business Partners, assisting them in the design, implementation, and optimization of RDBMS solutions. He is also involved in emerging technologies as part of the local UK team, investigating new ways of "doing things" with RDBMSs.

• Patrick Dantressangle

Marina Greenstein is an Executive IT Specialist with the IBM Data Servers and Application Development Team. She is an IBM Certified Solutions Expert and has experience in database application architecture and development. She joined IBM in 1995, and in the past 14 years Marina has assisted customers with their migrations from Microsoft SQL Server, Sybase, and Oracle databases to DB2. She has presented migration methodology at numerous DB2 technical conferences and at SHARE. She is also the author of multiple articles and tutorials about DB2 application development.

• Marina Greenstein

Sam Lightstone is a Program Director and Senior Technical Staff Member with the IBM DB2 for Linux, UNIX, and Windows development team, where he works on product strategy, architecture, and design. His recent work includes numerous topics in database language interfaces, data warehousing, autonomic computing, and relational database management systems. Sam is an IBM Master Inventor with over 30 patents and patents pending; he has published widely on self-managing database systems and is co-author of five books. Sam has been with IBM since 1991. He has a Master in Mathematics in Computer Science from the University of Waterloo.

• Sam Lightstone

Maksym Petrenko is a DB2 Enablement Specialist based at IBM Toronto Lab. Currently, he assists companies who have quickly moved their applications to latest DB2 version. Maksym joined IBM Toronto Lab in 2001 and has worked as a developer, technical support analyst, and lab services consultant. His experience includes supporting clients with installation, configuration, application development, and performance issues related to DB2 databases on Linux, UNIX, and Windows platforms. Maksym is a certified DB2 Advanced Database Administrator and DB2 Application Developer.

• Maksym Petrenko

Raanon Reutlinger joined IBM in 1995 after nearly 10 years in the application development field, working with a variety of databases. As an IBM Technical Sales Specialist and an expert in DB2 for Linux, UNIX, and Windows, he has worked with a wide range of customers implementing a variety of solutions, including DB2 on SAP, data warehousing and replication of over 1000 servers, as well as Federation Server. Raanon delivers DB2 courses and has experience with benchmarks and performance tuning, and was one of the authors of DB2 UDB V7.1 Performance Tuning Guide, SG24-6012. In January 2009, Raanon joined the IBM Toronto Lab, working out of Israel, as a DB2 Enablement Specialist, to work with customers on the early adoption of DB2 technologies.

• Raanon Reutlinger

Serge Rielau has worked with the DB2 for Linux, UNIX, and Windows SQL compiler for 12 years. He has a Master degree in Computer Science from the University of Kaiserslautern, Germany and participated in a year long internship at the IBM Almaden Research Lab. Presently, he is the technical architect responsible for SQL compatibility on DB2 9.7. As an expert in the SQL language, Serge is an active participant in the comp.databases.ibm-db2 newsgroup.

• Serge Rielau

Steve Schormann has been with IBM in various positions for over 29 years. For the past 17 years, Steve has been working in the DB2 development group in Toronto, with much of that time spent on performance engineering working with the performance group in IBM DB2 to achieve some world record performance benchmarks. For the past 1 1/2 years, Steve has been involved in database compatibility efforts within DB2, developing tools and assisting ISVs and customers in their migrations to DB2.

• Steve Schormann

Maria N Schwenger joined IBM in 2005 as a member of the Entity Analytic Solutions team, bringing in more then 10 years experiences in performance engineering, database architecture, administration, and development on Oracle and Microsoft SQL server, as well as extensive experiences in migration from older systems to relational databases. Currently, Maria is a part of the DB2 Open Database Technology team in IBM Canada, where she works with the "high touch" model with early release participants to promote DB2 technology early adoption, gathers feedback and references on pre-release products, and leads early enablement of applications written for competitive databases to DB2 9.7.

• Maria N Schwenger

ISBN

0738433519

IBM Form Number
SG24-7736-00

Number of pages
348