Create/Edit Db2 Index
Use this screen to update the Db2 index information for the Db2 table and index to be created. After you modify the index information, press END to return to the Target Environment.
Source Object
This section provides information about the following parameters:
SSID
Displays the Db2 subsystem ID of the extracted Db2 data.
Location
Displays the remote Db2 location name of the extracted Db2 data.
Index name
Displays the Db2 index name as it appears in the extract file.
Table Name
Displays the full Db2 object name, including creator ID of the table for which the index information was extracted.
Index columns
Displays the Db2 column names that are used in the index.
If the index has an expression (IX_EXTENSION_TYPE field in SYSINDEXES equals 'S'), the expression(s) are listed here instead of the index columns.
Index Type
Displays the index type as specified in the extract file. Valid types are:
Non-Partitioned
Simple tablespace (No partitions).
Partitioning Index
Index-based partitioning. The number of partitions are shown in the NUMPARTS field.
Data Partitioned Secondary
Data partitioned secondary index. The number of partitions are shown in the NUMPARTS field.
NUMPARTS
Displays the number of partitions.
Target Object
This section provides information about the following parameters:
SSID
Displays the Db2 subsystem ID of the Target Environment.
Location
Displays the remote Db2 location name of the Target Environment.
Table Name
Displays the full Db2 object name, including creator ID of the table for which the index information applies.
Index Creator
Specify the creator ID of the index. This field is prefilled with the target creator ID for Db2 objects as specified in the Load Object Specifications or Source to Target Mapping screen.
Index Name
Specify the name of the index. This field is prefilled with the extracted index name as specified or modified in the Load Object Specifications screen.
Index Type
Displays the index type as specified in the extract file. Valid types are:
Non-Partitioned
Simple tablespace (No partitions).
Partitioning Index
Index-based partitioning. The number of partitions are shown in the NUMPARTS field.
Data Partitioned Secondary
Data partitioned secondary index. The number of partitions are shown in the NUMPARTS field.
NUMPARTS
Displays the number of partitions.
Automatic Space Calculation
Displays whether you want File-AID/RDX to calculate the space allocation for new target index based on the extracted data or not. The calculated space will not exceed the space allocation of the source. It overrides the status set with the global Automatic Space Calculation field in the Target Environment screen. When this field displays an M, it indicates that the space allocation values have been entered manually which overrides the automatic space calculation.
STOGROUP
Specify the Db2 storage group in which the new index will reside. The storage group must already exist. This field is prefilled with the extracted storage group value.
PRIQTY
Number of kilobytes to be allocated for the file where your index will reside.
SECQTY
Amount of space (in kilobytes) to be allocated for the file if it exceeds the primary quantity.
BUFFERPOOL
Specify the Db2 buffer pool name associated with the index. This field is prefilled with the extracted value.
FREEPAGE
Specify the rate at which a page is left free when the index is loaded or reorganized.
PCTFREE
Specify the percentage of each page left free when the index is loaded or reorganized.
Primary Commands
The following File-AID/RDX-specific primary command is valid on this screen:
PARTITION (PART)
Displays the Index Partition Definition screen which lets you define the attributes for each index partition, if the tablespace is partitioned.
LimitKey (LK)
Displays the Limit Key Definition screen which lets you define the limit key value for each logical partition, if the tablespace is partitioned.
Index Partition Definition
The following panel is displayed when you enter the PARTITION primary command for a Db2 index in the Create Index screen. This screen lets you specify or modify the index partition information.
Command ===> Scroll ===> CSR
Primary commands: Change, Size
Line Commands: I = Insert; D = Delete; R = Repeat
Index: TSOID01.CONT_IDX Target NUMPARTS: 200
Table: TSOID01.CONTACT_TABLE Source NUMPARTS: 4
Automatic space calculation ===> (N = No; Y = Yes; M = Manual)
Target - Calculated total primary space . :
Source - Actual total primary space . . . : 58871
*** Any partition not displayed will be defined the same as the MODEL ***
PART STOGROUP PRIQTY SECQTY FREEPAGE PCTFREE
___ 4 STG002 10 20 20 20 MODEL
---- -------- ------- ------- -------- ------- --------------
___ 50 STG002 30 20 10 10
___ 100 STG002 30 20 10 10
___ 150 STG002 30 20 10 10
___ 200 STG002 30 20 10 10
******************************* Bottom of data ********************************
Use this screen to update the Db2 index partition information. After you view or modify the index partition information, press END to return to the Create Index screen.
Index
Displays the name of the index.
Target NUMPARTS
Displays the number of partitions.
Table
Displays the full Db2 object name, including creator ID of the table for which the index information applies.
Source NUMPARTS
Displays the number of partitions.
Automatic Space Calculation
Specify whether you want File-AID/RDX to calculate the space allocation for this new target index based on the extracted data or not. The calculated space will be distributed equally over all partitions. This setting overrides the global status set with the Automatic Space Calculation field in the Target Environment screen.
Target - Calculated total primary space
Displays the total calculated space requirement for the new index.
Source - Actual total primary space
Displays the total primary space allocation (at its original creation) of the index from which the data was extracted.
Partition Fields
By default, partition 1 is used as the model partition. For table-controlled partitioning, the highest partition of the source is used as the model partition. If all partitions have the same values as the model, no other partitions are displayed. Only partitions that are different from the model are displayed in the scrollable area below the model partition. Use the line commands to add or delete partitions that have different values than the model.
PART
For the model, it displays the number of the source partition used for the model. In the list of differing partition definitions, it displays the number of each partition that is different from the model partition.
STOGROUP
Specify the Db2 storage group in which the new tablespace partition will reside. The storage group must already exist. This field is prefilled with the extracted storage group value.
PRIQTY(K)
Specify the number of storage units allocated for the file in which your tablespace partition is to reside.
SECQTY(K)
Specify how much more space should be allocated for the file for the new tablespace partition if it exceeds the primary quantity.
FREEPAGE
Specify how often the system should leave a free page when the tablespace partition is updated.
PCTFREE
Specify how much of each page to leave free when the tablespace partition is updated.
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:
CHANGE (C)
The CHANGE command allows you to globally update the entry fields for the partition definition. Specify the change’ from string’ and change ‘to string’ in the CHANGE Command Window - Partition Definition and select the fields to change. See CHANGE Command Window for a description.
SIZE (S)
Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. See Target Environment - SIZE Screen with SHOW DATABASE for an example. SIZE is a toggle switch so enter SIZE again to return to the original format.
Line Commands
The following File-AID/RDX-specific line commands are valid on this screen:
I (Insert)
Enter the I (Insert) line command to insert a different partition after the current partition. The inserted partition(s) are based on the model partition. To insert more than 1 partition, enter the number of partitions with the I line command (nnn = 1 - 999). Then modify the partition values as required.
D (Delete)
Enter the D (Delete) line command to delete a partition definition in the list of different partitions from the model. To delete more than 1 partition, enter the number of partitions with the D line command (nnn = 1 - 999).
R (Repeat)
Enter the R (Repeat) line command to repeat a partition definition in the list of different partitions from the model. To repeat a partition definition more than once, enter the number of repetitions with the R line command (nnn = 1 - 999).
