Create Index: Partition Values panel
You use the Create Index: Partition Values panel to specify limit values for index entries in each partition.
Panel and field definitions
Process Options Utilities Help ZDT/Db2 (DFG2) Create Index: Partition Values Row 1 to 6 of 6 New Index: Owner . . . . . . . + Name . . . . . . . FRED + Table owner . . . . HFMUSER + Table name . . . . EMP + Parttn. Number Column Name Value + 1 EMPNO FIRSTNME MIDINIT 2 EMPNO FIRSTNME MIDINIT ******************************* Bottom of data ******************************** Command ===> Scroll PAGE F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward F9=Swap F10=Left F11=Right F12=Cancel
- Owner
- The name of the owner of the new index.
- Name
- The name of the new index.
- Table owner
- The SQLID used to create the table on which the index is being defined.
- Table name
- The table on which the index is created.
- Parttn. Number
- A sequential number showing the number of partitions defined. This is a display-only field.
- Column Name
- The name of the column.
- Value
- The smallest unit of data that is manipulated in SQL.
Parent panels
Child panels
None.