SYSINDEXCONTROL catalog table

The SYSINDEXCONTROL table contains rows that specify time windows to control the use of memory allocated for an index. Each row specifies a time window for enabling or disabling the use of memory for a specific index object. The schema is SYSIBM.

Tip: Fast index traversal is intended to be automatically controlled by Db2. Use the SYSIBM.SYSINDEXCONTROL catalog table only to define exceptions, when the automatic processing is unacceptable. Index performance optimization might be impeded if the number of rows in this catalog table becomes too large.
Table 1. SYSIBM.SYSINDEXCONTROL table column descriptions
Column name Data type Description Use
SSID
CHAR(4)
 The name of a Db2 subsystem. In data sharing, if this column is NULL, this row applies to all members of the data sharing group. G
PARTITION
SMALLINT
 Partition number. If this column is NULL, then the action is applicable to all partitions of the specified index. G
IXNAME
VARCHAR(128)
NOT NULL
 The name of the index. G
IXCREATOR
VARCHAR(128)
NOT NULL
 The schema of the index. G
TYPE
CHAR(1)
NOT NULL
WITH DEFAULT 'F'
 The purpose for which memory is being used:
F
A structure for fast index traversal (FTB)
 G
ACTION
CHAR(1)
NOT NULL
WITH DEFAULT 'A'
 The action that is being performed:
A
Start of changeThe index is candidate for FTB creation when the INDEX_MEMORY_CONTROL subsystem parameter setting is (SELECTED,n)End of change
D
Disable FTB creation
F
Force FTB creation
 G
MONTH_WEEK
CHAR(1)
 The meaning of the value in the DAY column.
M
A day of the month
W
A day of the week
 G
MONTH
SMALLINT
 Month during which the time window applies. Valid values are 1 (January) to 12 (December), or NULL.

If this column contains NULL, the time window applies to all months.

If MONTH_WEEK is 'W', this column value must be NULL.

 G
DAY
SMALLINT
 Day of the month or day of the week for which the time window applies.
  • If MONTH_WEEK='M', valid values are 1 (first day of the month) to the number of the last day of the month, or NULL.
  • If MONTH_WEEK='W', valid values are 1 (Monday) to 7 (Sunday), or NULL.
If this column contains NULL, the time window applies to every day of the month, or to every day of the week, depending on the value of the MONTH_WEEK column.		 G
FROM_TIME
TIME
 The time of day at which the time window begins.

If this column contains NULL, no limitation on the time exists. This column contains NULL if the TO_TIME column contains NULL.

 G
TO_TIME
TIME
 The time of day at which the time window ends.

If this column contains NULL, no limitation on the time exists. This column contains NULL if the FROM_TIME column contains NULL.

 G