For more information about DB2 UDB for z/OS syntax, see the reference information that is included with the product. There may be differences between DB2 syntax and the syntax for other vendors.
Property | Description |
---|---|
Name | Type a name. |
Label | Type a label. This label is displayed in visual diagrams. |
Schema | Shows the relational schema under which the object was created. |
System generated | Select to specify that no code is generated for this index during DDL generation. You can specify this option if the database will automatically generate an index. |
Property | Description |
---|---|
Unique | Select to specify that the index is a unique index. |
Clustered | Select to specify that the index is a clustered index. |
Padded | Select to specify the PADDED option. If you do not select this option the NOT PADDED option is used. |
Key columns | Specify columns for the key of the index. You can add, remove, or change the sort order for columns in the list. Click the ellipsis [...] toolbar button above the table to open a window where you can select columns and add them to the list. Select a column and click the arrow toolbar buttons to change the sort order. To delete columns, select a column and press Delete. |
Include columns | Specify non-key columns to include in the index. You can add, remove, or change the sort order for columns in the list. Click the ellipsis [...] toolbar button above the table to open a window where you can select columns and add them to the list. Select a column and click the arrow toolbar buttons to change the sort order. To delete columns, select a column and press Delete. |
Property | Description |
---|---|
Use no partitions | Select to specify that the index 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 index is partitioned. This option is only available if the table 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 index 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 data compression for the partition. |