Unique Keys Editor (IBM DB2 Z/OS)
Go Up to IBM DB2 for z/OS Object Editors
The Unique Keys Editor lets you manage columns, basic properties, and partitions for a unique key, as well as view storage details.
To edit a unique key
- Open an editor on the unique key. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Column |
Lets you manage columns that make up the primary key. On opening, this tab shows the existing columns. For each column, the listing shows the datatype (and if applicable the precision in brackets) and whether the table definition permits nulls in the target table column. Optionally you can: | |
Change the Sort order of a column. | ||
Click the New button and select a column name from the dropdown, to add a column to the primary key. | ||
Select a column and click the Drop button to delete the column from the primary key. | ||
Select a column and use the arrow buttons to reorder the columns in the primary key. | ||
Properties |
Lets you set the Buffer Pool, Piece Size, Close, and Copy properties. | |
Storage |
Lets you view the Storage Group and VCAT Catalog properties. Lets you set the Primary Space Allocation, Secondary Space Allocation, Erase, Free Page, Percent Free, and GBP Cache properties. | |
Partition |
Lets you work with partitions for the index. | |
Space |
Lets you view values in the following property groups: | |
Attributes |
Make Unique, System Required, Total Keys, Page Fetch Pairs, and Distinct Keys | |
Statistics |
Index Level, Cluster Ratio, Cluster Factor, Leaf Pages, Sequential Pages, and Density | |
Cards |
First Key and Full Keys | |
Comment |
For details on using this tab, see Adding a Comment to an object. | |
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.