DB2 Learning-table space types and table space management types

There are four different types of table spaces

1, REGULAR (general)

2, LARGE (Large)

3. System temporary (temporary)

4, user temporary (users temporary)

Ii. for table space, there are three types of management

1. SMS

2. DMS

3. Automatic Storage DMS

Three

SMS, Dmsà When you create a tablespace, you must know the device name and file name of the container that will be referenced, and also know the amount of space to allocate to the table space above the device name or file name

Automatic Storage Dms-->dbms automatically assigns a container (possibly multiple containers) to the table space based on the storage path

Examples are as follows:

Four

1) The pagesize of the buffer pool associated with a tablespace must be the same as the pagesize size of this tablespace, and the buffer pool must be activated before the tablespace

2) When the database is created, 3 initial tablespace is created, and the pagesize of the 3 initial tablespace is determined by the page size specified by the creation database

3) When the database is created, pagesize is not specified, the default is 4k

4) The size of the pagesize specified when you create database, and also the default size pagesize for all future Create Bufferpool, create tablespace