With 9.7 DB2 LUW version, IBM makes a nod to all Oracle DBAs, much more numerous in the DB2 market.
For this reason, 9.7 version has introduced Oracle compatibility modes that let you perform tasks in DB2 with the ease and knowledge that all Oracle DBAs have. However, it is important to know the terminology's translation between Oracle and DB2 if you intend to get into the DB2 world.
In this first article, I relate a number of items from which this introduction is simple and can be read DB2 documentation easily, including general terminology, updates, utilities, and views.
| GENERAL COMPONENTS | |
| ORACLE | DB2 LUW |
| Instance | Instance |
| File/Datafile | Container |
| Database | Database |
| Tablespace | Tablespace |
| Schema | Schema |
| Table | Table |
| Index | Index |
| View | View |
| Trigger | Trigger |
| Packages | Modules |
| Stored Procedures | Stored Procedures |
| SQL Plus | DB2 CLP |
| Data Block | Data Page |
| Dictionary | Catalog |
| Alert Log | Diag log |
| Redo Log | Log File |
| Segments | Space Consumming Objects |
| SGA | Instance/DB Shared Memory |
| CATALOG VIEWS | |
| ORACLE | DB2 LUW |
|
ALL_ |
SYSIBM.* SYSSTAT.* SYSCAT.* |
| UTILITIES | |
| ORACLE | DB2 LUW |
| RMAN IMPORT EXPORT SQL*loader DB_VERIFY ANALYZE |
BACKUP IMPORT EXPORT LOAD RESTORE REORG REORGCHK RUNSTATS |
| VERSIONS | |
| ORACLE | DB2 LUW |
| EXPRESS EDITION | EXPRESS-C |
| STANDARD EDITION ONE | EXPRESS EDITION |
| STANDARD EDITION | WORKGROUP EDITION |
| ENTERPRISE EDITION | ENTERPRISE SERVER EDITION |
I hope you find it useful.
Oscar Paredes
