---

Oracle to DB2 UDB Conversion Guide2003

ISBN: N/A
EAN: N/A

Year: 2004
Pages: 132

BUY ON AMAZON

• 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