Setting the rules for fast index traversal
The rules that determine which indexes or index partitions use fast index traversal are set in the Db2® catalog table SYSINDEXCONTROL. To set or change these rules, you must modify rows in this table.
Procedure
To set the rules for fast index traversal:
- On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
- On the System Administration (ADB2Z) panel, specify option 2I, and press Enter.
-
On the Manage Fast Index Traversal (ADB2Z2I) panel, specify
option 2, and press Enter.
Figure 1. Manage Fast Index Traversal (ADB2Z2I) panel ADB2Z2I n --------------- DD1A Manage Fast Index Traversal -------------- 15:17 Option ===> DB2 System: DD1A DB2 SQL ID: ADM001 1 - Display index memory use LIMIT . . (1-9999 or *) 2 - Display/Update SYSINDEXCONTROL table 3 - Display index traverse count Enter standard selection criteria. Index schema . . > Index name . . . > SSID . . . . . . Control action . (FTB creation: A - Automatic, D - Disable, F - Force)
-
On the Display/Update SYSINDEXCONTROL Table (ADB2Z2I2) panel,
use the D I, and U line commands to modify the SYSINDEXCONTROL table.
The entries in this table control which indexes or index partitions use fast index traversal. For detailed information on how to modify SYSINDEXCONTROL, see Enabling or disabling fast index traversal at the index level (Db2 13 for z/OS).
ADB2Z2I2 ------ DD1A Display/Update SYSINDEXCONTROL Table --- Row 1 to 3 of 3 Line commands: D - Delete I - Insert U - Update Index M From To Select SSID Index Name Schema T A W Month Day Time Time * * * * * * * * * * ------ ---- ------------------ --------- - - - ------ ------ -------- -------- DC1A GWIX5261 TS5761 F D W ? 7 ? ? DC1A ADBCATV1 TS5784 F F ? 2 4 ? ? DC1A ADBCIDX1 TS5784 F A M 3 22 11.41.09 17.13.11 ******************************* END OF DB2 DATA *******************************