Oracle to DB2 UDB Conversion Guide2003
- Table of Contents
- BackCover
- Oracle to DB2 UDB Conversion Guide
- Notices
- Preface
- Become a published author
- Comments welcome
- Chapter 1: Introduction
- 1.1 DB2 family of products
- 1.2 Terminology
- 1.3 Architecture overview
- 1.4 Parallel database architecture
- Chapter 2: Oracle Migration Project Planning
- 2.1 Migration planning
- 2.2 Porting preparation overview
- 2.3 Porting
- 2.4 Performance tuning
- 2.5 After the port
- 2.6 IBM migration service offering
- Chapter 3: MTK
- 3.1 MTK overview
- 3.2 MTK planning
- 3.3 MTK setup
- Chapter 4: Porting with MTK
- 4.1 Preparation for porting
- 4.2 Running MTK
- 4.3 Extracting or Importing metadata into MTK
- 4.4 The Convert task
- 4.5 The Refine task
- 4.6 The Generate Data Transfer Scripts task
- 4.7 Deploy to DB2
- 4.8 Next steps
- 4.9 Converting the remaining objects
- 4.10 Deployment of the remaining objects
- 4.11 Manual conversion for ORA_EMP database objects
- Chapter 5: Conversion Reference
- 5.1 Tools
- 5.2 Comparing SQL PL and inline SQL PL
- 5.3 Dynamic SQL
- 5.4 Cursor conversion
- 5.5 Collections
- 5.6 Condition handling
- 5.7 Package initialization
- 5.8 Global variables
- 5.9 Hierarchical queries
- 5.10 Print output messages
- 5.11 Implicit casting in SQL
- 5.12 Outer join
- 5.13 Decode statement
- 5.14 Rownum
- 5.15 INSERT, UPDATE, DELETE returning values
- 5.16 Select from DUAL
- 5.17 Manipulating date and time
- 5.18 Set operations
- 5.19 Function which returns rowtype
- 5.20 Local functions
- 5.21 Additional considerations
- Chapter 6: Data Conversion
- 6.1 Data conversion process
- 6.2 Time planning
- 6.3 Data movement through flat files
- 6.4 Alternative ways for data movement
- Chapter 7: Application Conversion
- 7.1 Application migration planning
- 7.2 Self-build application
- 7.3 Package applications migration planning
- Chapter 8: Script Conversion
- 8.1 Data Load scripts
- 8.2 Administration scripts
- 8.3 Tools and wizards
- 8.4 Report tools
- Chapter 9: Testing
- 9.2 Data checking technique
- 9.3 Code and application testing
- 9.4 Troubleshooting
- 9.5 Initial tuning
- Appendix A: DB2 UDB Product Overview
- DB2 UDB for Windows, UNIX, and Linux
- Appendix B: Data Types
- Supported SQL data types in CC
- Supported SQL data types in Java
- Mapping Oracle data types to DB2 UDB data types
- Appendix C: Oracle Call Interface (OCI) Mapping
- Appendix D: Converter for SQLLoader
- Converting control files for Oracle SQLLoader
- Generation of additional DB2 commands
- Appendix E: Terminology Mapping
- Appendix F: Example Oracle Database
- View definition
- Indexes
- Foreign keys
- Functions
- Packages
- Procedures
- Triggers
- Appendix G: Additional Material
- Using the Web material
- Related Publications
- Other publications
- Online resources
- How to get IBM Redbooks
- Help from IBM
- Index
- Index_Numerics
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- Index_Z
- List of Figures
- List of Tables
- List of Examples