For more information about DB2 UDB for z/OS syntax, see the reference information that is included with the product.
Property | Description |
---|---|
Name | Type a name. |
Label | Type a label. This label is displayed in a storage diagram. |
Type | Select a table space type. You can select LARGE, LOB, or BLANK. |
Define | Select to use the DEFINE YES option. |
Log | Select to use the LOG YES option. |
Member Cluster | Select to use the MEMBER CLUSTER option. |
Close | Select to use the CLOSE YES option. |
Erase | Select to use the ERASE YES option. |
DS size | Specify a DSSIZE value. |
Segment size | Specify a SEGSIZE value. |
Maximum rows | Specify a MAXROWS value. |
Lock Max | Specify a LOCKMAX value. If you select System, the value is set at -1 and the LOCKMAX SYSTEM option is used. |
Lock size | Select a LOCKSIZE option. You can select ANY, LOB, PAGE, ROW, or TABLESPACE. |
Buffer pool | Specify a group buffer pool name for the BUFFERPOOL option. |
Encoding scheme | Select an encoding scheme. You can select EBCDIC, ASCII, UNICODE, or NONE. |
Lock part | Select to use the LOCKPART YES option. |
Max partitions | Specify a MAXPARTITIONS value. |
Property | Description |
---|---|
Use no partitions | Select to specify that the table space is not partitioned. The options on this page change depending on whether you select this option or the Use partitions option. |
Use partitions | Select to specify that the table space is partitioned. The options on this page change depending on whether you select this option or the Use no partitions option. If you select this option, you can add or delete partitions by clicking the Add Partition or Delete Partition toolbar buttons. |
Storage group/VCAT | Click the ellipsis [...] button next to this field or cell to open a window so that you can specify whether to use the USING STOGROUP or the USING VCAT option. In the window, you can specify which storage group or integrated catalog facility catalog (VCAT) you want to use. The meaning of the USING STOGROUP or USING VCAT clause is different depending on whether the table space is partitioned or not partitioned. |
Primary quantity | Specify a PRIQTY value. Available only if you select to use a storage group. |
Secondary quantity | Specify a SECQTY value. Available only if you select to use a storage group. |
Free page | Specify a FREEPAGE value. |
PCT free | Specify a PCTFREE value. |
Compress | Select to specify the COMPRESS YES option. This option is not available for LOB or LARGE table spaces. |
Property | Description |
---|---|
Tables, Current® | Shows a list of the tables that are assigned to the
table space. Select a table from the list and click the > button to remove
the table from the list. Select a table and click Show Properties ![]() |
Tables, Available | Shows a list of available tables to add to the table
space. Select a table from the list and click the < button to move a table
to the Current tables list. Select a table and click Show
Properties ![]() |