Oracle到DB2迁移指南：步骤与案例分析

需积分: 3 83 浏览量更新于2024-07-27 1 收藏 6.08MB PDF 举报

"Oracle到DB2迁移指南" 这篇文档，即《Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows》，是一本详细的手册，旨在帮助用户将数据从Oracle数据库系统平滑迁移到IBM的DB2数据库系统。由一系列专业的IBM技术人员编写，这本书于2007年8月发布，适用于DB2 Version 9 for Linux, UNIX, 和 Windows，同时涵盖了Oracle 9i和Oracle 10g这两个版本。该指南提供了从Oracle到DB2迁移的逐步过程，确保了迁移过程的有效性和顺利性。其中包含了XML数据转换的实例，这在现代数据库应用中尤其重要，因为XML被广泛用于数据交换和存储。XML转换部分详细讲解了如何处理和迁移包含XML数据的表和对象，这对于保持数据完整性至关重要。此外，书中还深入介绍了Multi-Tool Kit (MTK)工具的使用方法。MTK是一个强大的工具集，它在数据库迁移过程中起到关键作用，能够帮助用户自动化和简化数据迁移、对象转换以及系统配置等工作。通过详细步骤指导，读者可以学习如何有效地利用MTK来完成迁移任务，减少手动操作和潜在错误。文档还包含了针对美国政府用户的版权信息，指出IBM根据GSA ADP Schedule Contract授予美国政府用户特定的使用、复制和披露限制。在正式使用这份信息和其支持的产品之前，读者应阅读"注意事项"部分，这部分通常包含了重要的法律声明、安全警告和其他使用指导。总而言之，《Oracle to DB2 Conversion Guide》是一份详尽的参考资源，对计划或正在进行Oracle到DB2迁移的IT专业人员具有极高的价值。它不仅提供了具体的操作步骤，还包含了实际案例和实用工具的使用，确保迁移过程既高效又安全。

xiv Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows

Trademarks

The following terms are trademarks of the International Business Machines Corporation in the United States,

other countries, or both:

AIX 5L™

AIX®

AS/400®

Cloudscape™

DB2 Connect™

DB2 Universal Database™

DB2®

developerWorks®

DRDA®

Informix®

IBM®

IMS™

iSeries®

i5/OS®

Lotus®

OS/390®

PowerPC®

POWER™

pureXML™

QMF™

Rational®

Redbooks®

Redbooks (logo) ®

REXX™

Tivoli®

WebSphere®

z/OS®

zSeries®

1-2-3®

The following terms are trademarks of other companies:

SAP R/3, SAP, and SAP logos are trademarks or registered trademarks of SAP AG in Germany and in

several other countries.

Oracle, JD Edwards, PeopleSoft, Siebel, and TopLink are registered trademarks of Oracle Corporation

and/or its affiliates.

Snapshot, and the Network Appliance logo are trademarks or registered trademarks of Network Appliance,

Inc. in the U.S. and other countries.

Enterprise JavaBeans, Java, JavaBeans, JDBC, JRE, J2EE, J2SE, Solaris, and all Java-based trademarks

are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Excel, Microsoft, SQL Server, Visual C++, Visual Studio, Windows NT, Windows Server, Windows, and the

Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

Intel, Intel logo, Intel Inside logo, and Intel Centrino logo are trademarks or registered trademarks of Intel

Corporation or its subsidiaries in the United States, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Linux is a trademark of Linus Torvalds in the United States, other countries, or both.

Other company, product, or service names may be trademarks or service marks of others.

Preface

IBM® DB2 has long been known for its technology leadership. This IBM

Redbooks® publication, intended for technical staff who are involved in an

Oracle® to DB2 conversion project, is an informative guide that describes how to

migrate the database system from Oracle to DB2 Version 9 on Linux®, UNIX®,

and Microsoft® Windows® platforms.

This book provides conversion methodology and step-by-step instructions for

installing and using IBM Migration Toolkit (MTK) to port the database objects and

data from Oracle to DB2. 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 that are useful for DBAs. The testing section provides

procedures and tips for conversion testing and database tuning. The laboratory

examples are performed under Oracle 10g and DB2 Version 9. However, the

migration process and examples can be applied to Oracle 7, 8, and 9i.

The team that wrote this book

This book was produced by a team of specialists from around the world working

at the International Technical Support Organization, San Jose Center.

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.

An Na Choi is a Field Technical Sales Specialist with the Information

Management department of SWG in South Korea. After graduating from

university, she worked for a local IT company for two years developing an

encyclopedia application. An Na has supported DB2 and Informix® products

including DB2 Database server, Tools, WebSphere® Information Integrator and

Informix Dynamic Server, and DB2 for SAP® for eight years. As a presales

engineer, An Na has performed benchmark tests and participated in Oracle to

DB2 conversion projects. She has extensive experience in deploying IBM

xvi Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows

Information Management solutions to many customers with DB2, Informix

Dynamic Server, DB2 on SAP, WSII and many other tools.

Marina Greenstein is a Senior Certified Consulting IT Software Specialist with

the IBM Database Migration Team. She is an IBM Certified Solutions Expert who

joined IBM in 1995 with experience in database application architecture and

development. During the 11 years Marina has been with the DB2 Migration

Team, she has assisted customers in their migrations from Microsoft SQL

Server™, Sybase, or 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 a white paper about DB2 migration.

Scott J Martin is a DB2 Technology Consultant with the IBM Innovation Center

(IIC) for Business Partners in Waltham, MA, which is part of IBM Developer

Relations. He has 25 years of IT experience with IBM, and is a certified

Advanced Database Administrator for DB2 LUW V8.1, a certified Application

Developer for the UDB Family, and a certified Database Administrator for DB2

for z/OS®. For the past four years with the IIC, Scott has helped business

partners convert their applications from Oracle, SQL Server, and MySQL to DB2

for LUW and DB2 for z/OS. In this role, Scott has also managed DB2

performance enablements and performed a variety of architecture and database

administration tasks supporting business partners. Prior to this, he spent 13

years with IBM Global Services performing Application Development, Database

Administration, and Database Tuning for DB2 mainframe environments.

Fraser McArthur is a DB2 Technical Consultant with the Information

Management Partner Enablement organization at the IBM Toronto Lab, where

he has worked for the last seven years. He focuses on assisting IBM Data

Services Business Partners, performing application migrations and performance

tuning, which can involve anything from low-level and detailed application

development and troubleshooting to high-level database design and

administration. Recently, his focus has been on DB2 pureXML™. Fraser also

conducts DB2 technical workshops and publishes the occasional article to IBM

developerWorks® for the DB2 community.

Carlos Eduardo Abramo Pinto is an IT Specialist for Database Administration

in IBM Global Services in Brazil, supporting IBM local and international

customers. He has more than 11 years of IT experience in a wide range of client

and server platforms, including technical and system support of the Windows

operating system, Oracle, DB2, and Microsoft SQL Server databases in UNIX,

Linux and Windows platforms. He is also specialized in Oracle Real Application

Clusters implementation and support. Carlos is an IBM DB2 Certified Database

Administrator on DB2 UDB V8.1 for Linux, UNIX and Windows, an Oracle

Certified Professional on Oracle 8i, 9i and 10g databases, a Microsoft Certified IT

Professional Database Administrator and Database Developer for Microsoft SQL

Preface xvii

Server 2005, a Microsoft Certified Database Administrator for Microsoft SQL

Server 7 and 2000, and a Microsoft Certified System Engineer on Windows NT®

4 and 2000.

Arthur V Sammartino is a Certified Consulting I/T Specialist with the IBM

Database Migration Team (also known as SMPO). He is responsible for assisting

customers who are considering a database migration from competitive RDBMS

products (Oracle, Sybase, or Microsoft SQL Server) to IBM DB2 residing on

Linux, UNIX, Windows, or the z/OS platforms. In addition to his conversion

responsibilities, his experience includes supporting clients with application

development environment and setup concerns, as well as migration tool

installation and education. Art is certified as both an IBM Database Administrator

and an IBM Application Developer. He has been a contributing author for the IBM

Redbooks DB2 UDB v7.1 Porting Guide, Oracle to DB2 UDB Conversion Guide,

and DB2 9 pureXML Guide. He also assisted with Microsoft SQL Server to IBM

DB2 UDB Conversion Guide, and was a co-author of the article “Using DB2

routines to ease migration.”

Nora Sokolof is a Certified Consulting Brand Sales IT Specialist with the IBM

DB2 Migration Team (also known as the SMPO). She holds a Master of Science

degree in Software Engineering from Pace University. She has been with IBM for

more than 20 years, and has held positions as a DB2, Informix, Oracle and

PeopleSoft® development DBA. She also designed the first IBM flexible benefits

enrollment database in 1993. Nora is an IBM Certified Database Administrator.

She is also the author of several white papers including “Transitioning from IBM

Informix to DB2 - Database Comparisons and Migration Topics”, and has

co-authored the following IBM Redbooks publications: Planning for a Migration of

PeopleSoft 7.5 from Oracle/UNIX to DB2 for OS/390, Database Transition:

Informix Dynamic Server to DB2 Universal Database, and Database Strategies:

Using XPS and DB2 Universal Database.

剩余749页未读，继续阅读

qiaolifeng

粉丝: 0
资源: 3

Oracle到DB2迁移指南：步骤与案例分析

Oracle_OBIEE_Tuning_Guide

Oracle_GoldenGate_11.2.1.0.3 for Oracle_11g_linux_x64

otl.zip_OTL_The Oracle_c++ db2 CLI_db2 cli_otl recordset

把Oracle数据库移植到Microsoft_SQL_Server_7.0.doc

Oracle_EPM_11_1_2_3_Tuning_Guide_v2

oracle备份RHCE_Linux_Study_Guide.pdf

深入浅出ORACLE ERP OM_USER_GUIDE 订单管理 中文操作手册 order manage.doc

db2_mysql_oracle数据库驱动架包

ORACLE移植DB2注意事项

oracle-DB2.rar_oracle

最新资源

深入浅出ORACLE ERP OM_USER_GUIDE 订单管理中文操作手册 order manage.doc