The 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.
Maximum number of partitions.
Maximum number of large partitions
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 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
ASCII encoding scheme.
EBCDIC encoding scheme.
You can set an MVS password (DSETPASS) on your data sets.
Specify the maximum number of rows that DB2 will consider placing on
each data page (MAXROWS). Valid values are from 1 to 255.
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.
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.
Compress the data.
Shows the added partition information.
Opens the Change partition management window to modify a partition and its properties.
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.