Select how you want the table space containers to be managed.
The space management can be changed later, by adding new table spaces to an existing database.
For a low-maintenance system-managed space (SMS), the table's files are created by the database and stored in the specified directory. The operating system manages the files. If you do not specify a path for the container, the database manager will create one on the default drive.
If you can use more than one physical drive, you can improve the performance of your database by adding a container to each drive.
Select how you want the table space containers to be managed.
The space management can be changed later, by adding new table spaces to an existing database.
For a high-performance database-managed space (DMS), the database creates one large file (container) as specified. Data is stored in this container and managed by the database. You must specify a size and the location of a DMS container.
If you can use more than one physical drive, you can improve the performance of your database by adding a container to each drive.
Shows the containers that are currently being used to store the table space. For SMS containers, the list shows the path of the container. For DMS containers, the list shows the full path, the type, and the size of the container.
Use the push buttons to add more containers, change existing containers, or remove containers.
Opens the Add Container window, where you can specify the path and, if applicable, the type and size of the container.
Opens the Change Container window, where you can specify the path and, if applicable, the type and size of the selected container.
Removes the selected container from this table space.