Required: Type a name (short identifier, must begin with a character with no special characters) for your table space that is unique to the data base. A simple table space; can contain more than one table Can contain only one table; each partition is a separate unit of storage that has a part of one table. You can have up to 254 partitions in a large table space. This holds more than one table; the space is divided into groups of pages, or segments, each the same size. A table space that holds large object values. Type a maximum number of partitions. Type a maximum number of large partitions Specify a maximum number of pages per segment. Optional: specify an allocated buffer pool name. Use any lock. Use lock on table only; only applicable for segmented table spaces. Use lock on table space only. Use lock on page only. Use lock on row only. Use a LOB value lock. Use the number of locks set at time of installation that an application process can hold at the same time in the table space. Specify a maximum number of locks that an application process can hold at the same time in the table space. Type a maximum number of locks allowed before escalating. If the size of the lock is Table space or Table (for segmented only), no value should be specified Use ASCII encoding scheme. Use EBCDIC encoding scheme. Specify the maximum number of rows that DB2 will consider placing on each data page (MAXROWS). Valid values are from 1 to 255. Specify the maximum size (DSSIZE) of either the partition or dataset. Specify the DSSIZE. Use the default CLOSE rule (CLOSE YES = close data sets when table space is not in use). For partitioned table spaces only. LOCKPART YES = only the partitions accessed are locked. Specify to write LOB column changes to the log. Specify to let DB2 choose where to put inserted data. User managed (VCAT). The integrated catalog facility catalog (ICF) used with this option identifies the catalog for the data set and supplies the first level qualifier for the data set name. DB2 creates a data set for the table space with the aid of the named storage group. Name of your ICF catalog. Name of your storage group. PRIQTY SECQTY Erase DB2-managed data sets when table space is dropped. Manage free space amount. Specify a number of data pages between each free space: 0 to 255. 0 = no pages are left free. Percentage of free space on a page Updated pages are written to the group buffer pool cache. Pages are cached as read from DASD. Cache the system pages. No caching is done. Compress the data. Let DB2 track the changed pages. Shows the added partition information. Opens the Add partition management window to add a partition and its properties. Opens the Change partition management window to modify a partition and its properties. Deletes a partition.

Submits the data in the window and closes the window.

Displays the SQL statements that would be generated by your choices in this window.

Cancels the uncommitted information and closes this window.