Oracle to DB2 Conversion Guide: Compatibility Made Easy

Oracle to DB2 Conversion Guide: Compatibility Made Easy
Author :
Publisher : IBM Redbooks
Total Pages : 456
Release :
ISBN-10 : 9780738438757
ISBN-13 : 0738438758
Rating : 4/5 (57 Downloads)

Book Synopsis Oracle to DB2 Conversion Guide: Compatibility Made Easy by : Yvonne Chan

Download or read book Oracle to DB2 Conversion Guide: Compatibility Made Easy written by Yvonne Chan and published by IBM Redbooks. This book was released on 2014-07-03 with total page 456 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication describes IBM DB2® SQL 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, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools 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 the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.


Oracle to DB2 Conversion Guide: Compatibility Made Easy Related Books

Oracle to DB2 Conversion Guide: Compatibility Made Easy
Language: en
Pages: 456
Authors: Yvonne Chan
Categories: Computers
Type: BOOK - Published: 2014-07-03 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL pro
Architecting and Deploying DB2 with BLU Acceleration
Language: en
Pages: 446
Authors: Whei-Jen Chen
Categories: Computers
Type: BOOK - Published: 2015-05-11 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers br
DB2 Essentials
Language: en
Pages: 783
Authors: Raul F. Chong
Categories: Computers
Type: BOOK - Published: 2013 - Publisher: IBM Press

DOWNLOAD EBOOK

This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today's business challenges. It discusses key features
IBM Midmarket Software Buying and Selling Guide
Language: en
Pages: 204
Authors: LindaMay Patterson
Categories: Computers
Type: BOOK - Published: 2010-07-12 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

The IBM® Midmarket Software Buying and Selling Guide is tailored specifically to help the management and IT staff of small and midsized businesses evaluate how
IBM Workload Deployer: Pattern-based Application and Middleware Deployments in a Private Cloud
Language: en
Pages: 424
Authors: Carla Sadtler
Categories: Computers
Type: BOOK - Published: 2012-03-22 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

IBM® Workload Deployer provides a solution to creating, deploying, and managing workloads in an on-premise or private cloud. It is rich in features that allow