Indexes Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Indexes Editor lets you manage basic, storage, and space properties for an index, as well as work with its columns and partitions.

To edit an index

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you manage the columns or key-expressions that make up the index. On opening, this tab shows the existing columns/key-expressions.

NOTE: Key-expression functionality is only enabled if the Index on Expression setting is enabled on the Properties tab. Optionally you can:

Change the Sort order of a column or key-expression.

If Index on Expression is disabled, click the New button and select a column name from the dropdown to add a column to the index.

If Index on Expression is enabled, click the New button and type a valid key-expression in the Expression field, to add an expression to the index.

Select a column or key-expression and click the Drop button to delete the column from the index.


Lets you work with the Buffer Pool, Piece Size, Close, Copy, Compress, Index on Expression, and Padded properties. For more information on these properties, see Indexes (DB2 z/OS) - Properties.


Lets you select a dataset management scheme and provide associated attribute values. For details, see Indexes (DB2 z/OS) - Storage.


Lets you work with partitions for the index. For each data partition, the listing shows the storage group, VCAT Catalog, primary and secondary space allocations, and if appropriate, the free space percentage, GBP Cache, limit key value, and erase on delete settings. Optionally, you can select a partition and click the Edit button top open an editor that lets you edit that partition.


Lets you view the following property groups:


Make Unique, System Required, Total Keys, Page Fetch Pairs, and Distinct Keys


Index Level, Cluster Ratio, Cluster Factor, Leaf Pages, Sequential Pages, Density, DASD Storage, and Data Blocks/Key.


First Key and Full Keys


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.