Translation of terminology Oracle - DB2 LUW

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_ 
USER_ 
DBA_ 
V$ 
GV$

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

www.db2util.es

 

 

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.