SYSIBM.SYSINDEXES_HIST
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

Contains rows from SYSINDEXES. Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.

Nome da coluna Tipo do dado Descrição Uso
 NAME  VARCHAR(18) NOT NULL  Name of the index.  G
 CREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the index.  G
 TBNAME  VARCHAR(18) NOT NULL  Name of the table on which the index is defined.  G
 TBCREATOR  VARCHAR(18) NOT NULL  Authorization ID of the owner of the table.  G
 CLUSTERING  CHAR(1) NOT NULL  Whether CLUSTER was specified when the index was created:

 N      No
 Y      Yes		  G
 NLEAF  INTEGER NOT NULL
 WITH DEFAULT -1		  Number of active leaf pages in the index. The value is -1 if statistics have not been  gathered.  S
 NLEVELS  SMALLINT NOT NULL
 WITH DEFAULT -1		  Number of levels in the index tree. If the index is partitioned, it is the maximum of  the number of levels in the index tree for all the partitions. The value is -1 if  statistics have not been gathered.  S
 STATSTIME  TIMESTAMP NOT NULL  If RUNSTATS updated the statistics, the date and time when the last invocation of  RUNSTATS updated the statistics.
 The default value is '0001-01-01-00.00.00.000000'.		  G
 FIRSTKEYCARDF  FLOAT(8) NOT NULL
 WITH DEFAULT -1		  Number of distinct values of the first key column. This number is an estimate if  updated while collecting statistics on a single partition. The value is -1 if statistics  have not been gathered.  S
 FULLKEYCARDF  FLOAT(8) NOT NULL
 WITH DEFAULT -1		  Number of distinct values of the key. The value is -1 if statistics have not been  gathered.  S
 CLUSTERRATIOF  FLOAT(8) NOT NULL  Percentage of rows that are in clustering order. For a partitioning index, it is the  weighted average of all index partitions in terms of the number of rows in the  partition. The value is 0 if statistics have not been gathered. The value is -2 if the  index is for an auxiliary table.  G
 SPACEF  FLOAT(8) NOT NULL
 WITH DEFAULT -1		  Number of kilobytes of DASD storage allocated to the index space partition. The  value is -1 if statistics have not been gathered.  G
 IBMREQD  CHAR(1) NOT NULL
 WITH DEFAULT 'N'		  A value of Y indicates that the row came from the basic machine-readable material  (MRM) tape. For all other values, see Release dependency indicators in topic D.0.  G