SQL - SYSIBM.SYSINDEXCONTROL - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSINDEXCONTROL
Db2 for z/OS 12.0.0

A tabela SYSINDEXCONTROL contém linhas que especificam janelas de tempo para controlar o uso de memória alocada para um índice.
Cada linha especifica uma janela de tempo para habilitar ou desabilitar o uso de memória para um objeto de índice específico.
O esquema é SYSIBM.

Importante:
A travessia rápida de índice deve ser controlada automaticamente pelo Db2. A otimização do desempenho do índice pode ser impedida se o número de linhas nesta tabela de catálogo se tornar muito grande./

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.

Important:
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:
F
A structure for fast index traversal (FTB)
 G
ACTION CHAR(1)
NOT NULL
WITH DEFAULT 'A'		 The action that is being performed:
F
Force FTB creation
D
Disable FTB creation
A
The index is candidate for FTB creation when the INDEX_MEMORY_CONTROL subsystem parameter setting is (SELECTED,n)
 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

© Copyright IBM Corp.