Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®

Space Usage with MDC Tables

The following section will use the table space MDCTS, defined as:

					create tablespace mdcts pagesize 4k
					  managed by database using (file 'd:\mdcts' 10000) extentsize 32
				

and the table T1, defined as:

					create table t1(c1 varchar(30), c2 int, c3 int) organize by (c1, c2) in mdcts
				

for the basis of discussion.

Before creating the table, there will be four extents used for the container tag and three extents of table space overhead. The LIST TABLESPACES command does not show the pages used by the container tag, so the output of the command would show three extents used as follows:

					Tablespace ID                                 = 3
					  Name                                        = MDCTS
					  Type                                        = Database managed space
					  Contents                                    = Any data
					  State                                       = 0x0000
					    Detailed explanation:
					      Normal
					 Total pages ...