| Subcribe via RSS

Terminology mapping between Oracle and DB2

August 28th, 2009 Posted in IBM DB2

For people wants move from Oracle to DB2, this a little terminology mapping:

Oracle DB2
Instance Instance
Redo logs Logs files
Statement cache Package cache
Datafiles DMS containers
Data cache Buffer pools
Data dictionary System catalog
Datafiles Containers
Segments Objects
Data blocks Pages
Database Link Federated System

And also, some useful mapping between Oracle and DB2 products:

Oracle DB2
Oracle EE DB2 Entreprise
Oracle Gateway DB2 Connect
SQL *PLUS DB2 CLP / DB2 CLP PLUS
PL/SQL SQL Procedural Language

You should also take care of the “package” term. For Oracle it’s a logical grouping of PL/SQL blocks that can be invoked by other PL/SQL applications, and for DB2 it’s a precompiled access plan for an embedded static SQL application stored in the server.

Tags: , ,
This entry was posted on Friday, August 28th, 2009 at 8:25 pm and is filed under IBM DB2. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Terminology mapping between Oracle and DB2”

  1. Saurabh Jain Says:

    October 28th, 2009 at 11:19 am

    One correction – with DB2 9.7, we have DB2 CLP PLUS in comparison with SQL *PLUS.


  2. Stéphane Journot Says:

    October 28th, 2009 at 8:22 pm

    You’re right, I correct it
    Thanks.


Leave a Reply