Table space requirements

The following table lists the storage type, buffer pool, and the management type for the table spaces table space requirements.

Definitions

Only the USERS, INDX, BLOB_TBL_DATA, TEMP_USER, and TEMP_SYSTEM table spaces are required for a default development environment. In a production environment, create all listed table spaces and buffer pools so highly used tables such as ITA, ITD, ITM, ICM, and LCK can be associated to separate table spaces when you run the create_schema.sh script.

Note: You must use a table space-mapping file to use these additional table spaces and buffer pools. This file is described in the Run schema creation scripts section.

Management: Automatic for the following table spaces.

Table space	Type	Buffer pool
USERS	LARGE	USERSBP
INDX	LARGE	INDXBP
BLOB_TBL_DATA	LARGE	BLOBBP
XML_DATA	LARGE	XML_DATA_BP
XML_LARGE_DATA	LARGE	XML_LARGE_BP
XML_INDEX	LARGE	XML_INDX_BP
TEMP_USER	USER TEMPORARY	TEMPUSRBP
TEMP_SYSTEM	SYSTEM TEMPORARY	TEMPSYSBP
ITA_DATA	LARGE	ITA_DATA_BP
ITM_DATA	LARGE	ITM_DATA_BP
ITD_DATA	LARGE	ITD_DATA_BP
ICM_DATA	LARGE	ICM_DATA_BP
LCK_DATA	LARGE	LCK_DATA_BP
ITA_IX	LARGE	ITA_IX_BP
ITM_IX	LARGE	ITM_IX_BP
ITD_IX	LARGE	ITD_IX_BP
ICM_IX	LARGE	ICM_IX_BP
LCK_IX	LARGE	LCK_IX_BP
TEMP_USER32	USER TEMPORARY	TEMPUSRBP32
TEMP_SYSTEM32	SYSTEM TEMPORARY	TEMPSYSBP32

There are two types of table space management:

Database-managed space (DMS): Space that is managed by DB2®.
System-managed space (SMS): Space that is managed by the operating system.

The TEMP_USER and TEMP_USER32 table spaces are SMS user temporary table spaces that store the declared temporary tables after the application defines such tables. The use of temporary table space increases throughput of data while you run complex SQL queries that need extra space to process large amounts of data.

By creating intermediate tables that are used to process large amounts of data that is made available during the application connection, you reduce the need to rebuild these intermediate tables, improving the performance of the system.

The TEMP_SYSTEM and TEMP_SYSTEM32 are SMS system temporary table spaces that are used during SQL operations for internal temporary tables, for sorting, storing intermediate results, and for reorganizing tables and other transient data.

When you create physical and logical volumes for the table spaces, physically spread the table spaces in different disks to use parallel IO. Specifically, spread the ITA_IX table space into different high-performance disks because it is a high-use and high-growth table space.

The table spaces that are listed need to be created with the AUTORESIZE YES option.

Instead of using database or operating system-managed table spaces that you can also use Automatic Storage for all the table spaces. By using the Automatic Storage option, the database manager automatically manages the container and space allocation for the table spaces as you create and populate them. This is the default behavior when a new database is created.