DB2 fundamental – Tablespace (additional the different between Oracle’s and Its)

Similar to Oracle database, DB2 also has the conception of table space. A table space is the storage structure containing tables, indexes, larger objects/long data such as LOB Object, therefore the table space orginze  these datas in database to group them into logical structure.

 

In physically, the table  space contains some storage area, such as file, raw device, NAS or other storage. In db2 we name them container. that is same as the datafile in Oracle database, obviously the datafile is not only specify the file and the container is also. And the container's meaning is more exactly than datafile.

 

What can table space offer?

 

Table space make the storage management more easily and regular
ly. Tables, Indexes and Large Object/Long Data all are the logical kind of objects. They all store the file, device or othre storages. By table space we can orgnize them into differenet group. And we can store the tables, indexes and so on which are accessed frequently on the fast device.  Constrarily the historical data which is retrieved ocassionally on the slower or less expensive device.