Creating a database on an instance of DB2 - Documentation for BMC Database Automation 8.9

TypeFieldDescription Create User Tablespace(Optional) Specifies the definition of the initial user table space. Selecting this check box, displays the following fields. Managed BySYSTEMSpecifies that the table space is to be an SMS table space. When the type of table space is not specified, the default behavior is to create a regular table space.DATABASESpecifies that the table space is to be a DMS table space. When the type of table space is not specified, the default behavior is to create a large table space.AUTOMATIC Specifies that the table space is to be an automatic storage table space.User Tablespace System ContainersContainers (Optional)Type the location of the user tablespace system containers. You can add as many locations as you want by clicking Add. Note: This field is displayed only when you select SYSTEM in the Managed By field. User Tablespace Database ContainersContainers (Optional)Type the location of the user tablespace database container. You can add as many locations as you want by clicking Add. Note: This field is displayed only when you select DATABASE in the Managed By field. User Tablespace ConfigurationExtent Size(Optional) Type the default extent size of table spaces in the database.Prefetch Size(Optional) Type the number of PAGESIZE pages that will be read from the table space when data prefetching is being performed.Overhead(Optional) Type the number that specifies the I/O controller usage, disk seek, and latency time in milliseconds. This value is used to determine the cost of I/O during query optimization. If this value is not the same for all containers, the number should be the average for all containers that belong to the table space.Transfer Rate(Optional) Type the time to read one page into memory. This value is used to determine the cost of I/O during query optimization. If this value is not the same for all containers, the number should be the average for all containers that belong to the table space.File System Caching(Optional) Specify that all I/O operations in the target table space are to be cached at the file system level.Autoresize(Optional) Specifies whether or not the auto-resize capability of a DMS table space or an automatic storage table space is to be enabled. Auto-resizable table spaces automatically increase in size when they become full. The default is NO for DMS table spaces and YES for automatic storage table spaces. Selecting Autoresize displays the following fields. Initial Size: (Optional) Type the initial size, per database partition, of an automatic storage table space.This parameter is only valid for automatic storage table spaces. This field accepts only integers. Increase Size: (Optional) Type the amount, per database partition, by which a table space that is enabled for auto-resize will automatically be increased when the table space is full, and a request for space has been made. This field accepts only integers. Max Size: (Optional) Type the maximum size to which a table space that is enabled for auto-resize can automatically be increased. If the table space is auto-resizable.