A table space is one or more data sets in which one or more tables are stored. Figure 1 contains examples of SQL statements that create a table space. There are other methods of allocating a table space. For details, see the DB2® documentation.

Member RACDBUTB in SYS1.SAMPLIB contains statements that create a table space.

CREATE TABLESPACE tablespacename IN databasename
       LOCKSIZE TABLESPACE
       SEGSIZE  64
       PCTFREE  0
       USING STOGROUP storagegroup
          PRIQTY 2000
          SECQTY 500
          CLOSE  NO
          ;

The user must supply the name of the table space (tablespacename) and the storage group (storagegroup). The sample shows a value of 64 for SEGSIZE, 2000 for PRIQTY, and 500 for SECQTY.

The samples in RACDBUTB put all of the tables into one table space. The sample also suggests using a segment size because segmented table spaces improve performance. Users might want to define their own table spaces rather than use table spaces that are defined by the storage group.

Installations have a number of other options, such as the number of table spaces to use, the type of spaces, and the security for the data. They might want to keep the number of tables per table space fairly small for better performance and might want to consider putting the larger tables into separate table spaces.