DB2 UDB for z/OS table space properties

Use the Properties view to modify the properties of a DB2® UDB for z/OS® table space.

For more information about DB2 UDB for z/OS syntax, see the reference information that is included with the product.

General page
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.
Partitions page
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.
Tables page
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 Show Properties icon to open the Properties view for the selected object.
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 Show Properties icon to open the Properties view for the selected object.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback