Oracle to DB2 UDB Conversion Guide2003

Chapter 1: Introduction

Table 1-1: Mapping of Oracle terminology to DB2 UDB

Table 1-2: Database memory segments and parameters

Table 1-3: Data Dictionary and Catalog

Table 1-4: Shared disk architecture vs. shared nothing architecture

Chapter 4: Porting with MTK

Table 4-1: Disk space requirements on AIX

Table 4-2: Disk space requirements on AIX

Table 4-3: Disk space requirements on Windows

Table 4-4: Differences between SMS and DMS table spaces

Table 4-5: Message 20 objects

Chapter 5: Conversion Reference

Table 5-1: Mapping of conditional statements

Table 5-2: Mapping Oracle and DB2 Cursor operation

Table 5-3: Mapping of cursor attributes

Table 5-4: Mapping of join definition

Table 5-5: Mapping of ROWNUM function

Table 5-6: Use of dummy table for system information

Table 5-7: Mapping of set operations

Chapter 7: Application Conversion

Table 7-1: JDBC driver

Table 7-2: Return code mapping from OCI to CLI functions

Chapter 8: Script Conversion

Table 8-1: V$ views and table functions

Table 8-2: Commands and DDL conversion

Chapter 9: Testing

Table 9-1: Aggregations for data migration verification

Table 9-2: List of monitor switches and related DBM parameters

Table 9-3: Common snapshot table functions

Table 9-4: Parameters for AUTOCONFIGURE command

Appendix B: Data Types

Table 9-5: Oracle to DB2 data type mapping

Table 9-6: SQL data types mapped to Java declarations

Table 9-7: Mapping Oracle data types to DB2 UDB data types

Appendix C: Oracle Call Interface (OCI) Mapping

Table 9-8: Connect/initialize/authorize

Table 9-9: Handles/descriptors

Table 9-10: Transaction management

Table 9-11: Bind/define/describe

Table 9-12: Prepare/execute/fetch

Table 9-13: Miscellaneous

Appendix E: Terminology Mapping

Table 9-14: Oracle Terminology to DB2 UDB mapping