Oracle to DB2 UDB Conversion Guide2003
|
| < Day Day Up > |
|
1.2 Terminology
Before getting into conversion process, a clear understanding between the terminologies used in Oracle and DB2 UDB help the readers to understand and map each terminology between Oracle and DB2 UDB. This section discusses some of the terminologies, and a mapping between these terminologies is given.
1.2.1 Terminology mapping
Table 1-1 provides a quick reference of commonly used terminologies in Oracle and DB2 UDB. More information about the terminology mapping is provided in Appendix E, "Terminology mapping" on page 393.
| Oracle | DB2 UDB |
|---|---|
| Instance | Instance |
| Database | Database |
| Initialization File | Database Manager Configuration File |
| Table spaces | Table spaces |
| Data blocks | Pages |
| Extents | Extents |
| Datafiles | DMS containers |
| Redo Log Files | Transaction Log Files |
| PL/SQL | SQL/PL |
| Data Buffers | Buffer Pool |
| SGA | Database Manager and Database shared memory |
| Data Dictionary | Catalog |
| Library Cache | Package Cache |
| Large Pool | Utility heap |
| Data Dictionary cache | Catalog cache |
| SYSTEM tablespace | SYSCATSPACE tablespace |
|
| < Day Day Up > |
|