Create Index: Partitions panel
You use the Create Index: Partitions panel to specify space information for index partitions.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Index: Partitions Row 1 to 1 of 1
New Index:
Owner . . . . . . . +
Name . . . . . . . IND1 +
Table owner . . . . +
Table name . . . . TABLE1 +
Parttn. VCAT STOGROUP Primary Secndry Erase Free % Grp BP
Cmd Number Name Name + Space Space Data? Pages Free Caching
1
******************************* 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.
- Table owner
- The SQLID used to create the table on which the index is being defined.
- Name
- The name of the new index.
- Table name
- The table on which the index is created.
- Cmd
- An input selection field. When the panel is first displayed, the table contains 1 row, with default values entered. To define additional partitions type 'I' in the selection field and press Enter. You can also type 'R' to repeat the current definition. Other valid selection commands are i and r followed by an integer.
- Parttn. Number
- A sequential number showing the number of partitions defined. This is a display only field.
- VCAT Name
- The VCAT name used to define user-specified data sets. This is an input field. It is mutually exclusive with the STOGROUP parameter.
- STOGROUP name
- The Db2® storage group name in which the index data set is defined. This is an input field. It is mutually exclusive with the VCAT parameter.
- Primary Space
- The primary space allocation for the partition, entered in kilobytes.
- Secndry Space
- The secondary space allocation for the partition, entered in kilobytes.
- Erase Data?
- A YES/NO value corresponding to the ERASE YES/NO clause.
- Free Pages
- Free pages results in Db2® leaving an empty page every n pages (n is what is specified).
- % Free
- The value specified here results in Db2® leaving n% (n is what is specified) of each page free.
- Grp BP Caching
- This corresponds to the GBPCACHE clause of the create statement (for each partition). These options only apply in a data sharing environment.
Parent panels
Child panels
None.