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.
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:
|
G |
ACTION |
CHAR(1)
NOT NULL WITH DEFAULT 'A' |
The action that is being
performed:
|
G |
MONTH_WEEK |
CHAR(1)
|
The meaning of the value in the DAY column.
|
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.
|
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 |