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
Child panels
None.