Creating a DB2 table space

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.

Figure 1. Sample SQL Utility Statements Defining a Table Space

CREATE TABLESPACE tablespacename IN databasename
       LOCKSIZE    TABLESPACE
       SEGSIZE 4
       PCTFREE 0
       BUFFERPOOL BP32K
       USING STOGROUP storagegroup
          PRIQTY 20000
          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 4 for SEGSIZE, 20000 for PRIQTY, and 500 for SECQTY.

Member IRRADUTB in SYS1.SAMPLIB contains statements that create a table space. The sample in IRRADUTB puts all of the tables into one table space. The sample also suggests using a segment size, because segmented table spaces improve performance. You may want to define your own table spaces rather than use table spaces that are defined by the storage group.

You 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. You may want to keep the number of tables per table space fairly small for better performance, and you may want to consider putting the larger tables into separate table spaces.