Wikibooks

Oracle and DB2, Comparison and Compatibility/Storage Model/Tables/DB2

< Oracle and DB2, Comparison and Compatibility | Storage Model | Tables

DB2

edit

Because tables are logical structures, they are represented in DB2 the same way as they are in Oracle – Tables contain Rows and Columns. The analogous structures that can be seen in the two databases are that DB2 stores data in Pages, and Oracle uses Blocks. Both pages and blocks are fetched as a single contiguous chunk as extents. Within Oracle, extents are organized into segments, in DB2 they are managed in containers. Both containers and segments are contained within DB2 and Oracle tablespaces respectively.

DB2 Tables in a Tablespace
 
Retrieved from "https://en.wikibooks.org/w/index.php?title=Oracle_and_DB2,_Comparison_and_Compatibility/Storage_Model/Tables/DB2&oldid=3583159"