Create Index: Partitions panel

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.