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.
|Stored Procedures||Stored Procedures|
|SQL Plus||DB2 CLP|
|Data Block||Data Page|
|Alert Log||Diag log|
|Redo Log||Log File|
|Segments||Space Consumming Objects|
|SGA||Instance/DB Shared Memory|
|STANDARD EDITION ONE||EXPRESS EDITION|
|STANDARD EDITION||WORKGROUP EDITION|
|ENTERPRISE EDITION||ENTERPRISE SERVER EDITION|
I hope you find it useful.