Create Index: Options panel

You use the Create Index: Options panel to specify information to define options for the index to be created.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)                Create Index Options

 Data Storage Options:
    Enter '/' to select option
    / Close when not in use
      Erase data on delete
      Defer building index
    / Define data set now
      Allow COPY of index

 Group Buffer Pool Usage:
    Write to the group buffer pool
      1. Changed
      2. All
      3. None



 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel

You can use the first group of input fields to select the appropriate option with the '/' selection character. The following section describes the options:

Close when not in use: This corresponds to the CLOSE YES/NO clause. It relates to how Db2® handles open data sets when the limit for the maximum number of open data sets is reached.
Erase data on delete: This corresponds to the ERASE YES/NO clause in the 'USING' block. ERASE YES means that the data sets associated with the partition are overwritten with binary zeros when the partition is deleted (dropped).
Defer building index: This corresponds to the DEFER YES/NO clause. The default value is DEFER NO, meaning that the index is built when the CREATE INDEX statement is executed.
Define data set now: This corresponds to the DEFINE YES/NO clause. The default value is DEFINE YES, meaning that the data sets used for the index are created when the CREATE INDEX statement is executed.
Allow COPY of index: This corresponds to the COPY YES/NO clause. The default value is COPY NO, meaning that it is not possible to use the COPY utility against the index.

The second input field on the panel contains three options relating to the use of the grouped buffer pool. You can select the required option by typing the appropriate number. This corresponds to the GBPCACHE clause in the create statement syntax.

Parent panels

Create Index panel

Child panels

None.

Related tasks

Creating an index