DB2 Resources for those trained on Oracle
svisser1 2700018UK9 Visits (2131)
Why would you want to learn DB2? You may wish to broaden your skills to make you more marketable in case you are affected by your company downsizing. Perhaps your company will choose to install DB2 in addition to your current database system, or instead of your current system. Maybe you'll try using DB2 and prefer it to your current system because of specific features or due to ease of use. Whatever the reason, we have the resources for you. Please note that many of these resources are FREE.
For starters, I would like to thank Amyris Rada for helping me make this information as complete as it can be! Some of the articles that I'll be mentioning were written by Amyris and she has plans to use her talents in this area for future projects, so stay tuned.
DB2 Universal Database versus Oracle data movement
A comparative guide
Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8
IBM DB2 UDB versus Oracle backup and recovery
A comparative guide
Converting Oracle Pro*C Programs to DB2 Universal Database
Migrating Recursive SQL from Oracle to DB2 UDB
Using DB2 routines to ease migration
Truncating tables, getting the client's host name, and calling stored procedures from UDFs
Oracle to DB2 UDB Conversion Guide
This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff who are involved in an Oracle to DB2 UDB conversion project.
This redbook provides migration planning guidelines, with step-by-step instructions for installing and using IBM Migration Toolkits (MTK) to port the database objects and data from Oracle to DB2 UDB. It illustrates with examples how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed along with the differences in features and functionality of the two products.
In addition, you can find script conversion samples for data loading, database administration, and reports, which are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning.
SQL In A Nutshell, 2nd Edition
by Kevin Kline, Daniel Kline, Brand Hunt
This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL).
Understanding DB2(R) : Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.
DB2(R) SQL PL : Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
by Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul F. Chong, Michael Gao, Fraser McArthur, Paul Yip
DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions. Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this book indispensable.
IBM MTK Toolkit Web
The IBM DB2 Migration Toolkit helps you migrate from Oracle (versions 7, 8i and 9i) to DB2 UDB V8.1 and DB2 V8.2 on Windows, UNIX and Linux.
Sample Database Migration Tutorial Using IBM DB2 Migration Toolkit
Automate the Switch to DB2 Using the IBM DB2 Migration Toolkit
The no-charge IBM DB2 UDB Migration Toolkit can simplify and improve your migration to DB2 Universal Database (DB2 UDB). This migration utility provides a wizard and an easy-to-use interface with only five steps to help you quickly convert existing Sybase, Microsoft SQL Server, Oracle, and Informix database objects to DB2 UDB.
There are a number of DB2 UDB Porting Guides and other documents available to assist you in moving your database and application from its existing DBMS to DB2 UDB.
DB2 Sample UDFs for migration:
PS: We have resources for those using SQL Server, Sybase, and other products, but I felt that I should cover those in a separate post.