Chapter 1: Introduction

---

Overview

Since migrating from Oracle to DB2 UDB requires a certain level of knowledge in both environments, the purpose of this chapter is to introduce the architectural overview of both Oracle and DB2 UDB. This is meant to facilitate the understanding of both architectures, taking into consideration that the reader may be an Oracle or a DB2 DBA.

This chapter includes the following points:

• DB2 family of products

• Terminology

• Architectural overview including:

  • Processes architecture

  • Memory architecture

  • Directory structure

  • Oracle data dictionary and DB2 catalog

  • Database connectivity

  • Replicating

  • Partitioned database architecture

---