|
SYSIBM.SYSINDEXPART_HIST www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains rows from SYSINDEXPART. Rows are added or changed in this table when RUNSTATS collects history statistics.. Rows in this table can be inserted, updated, and deleted.
| Nome da coluna | Tipo do dado | Descrição | Uso |
| PARTITION | SMALLINT NOT NULL | Partition number. Zero if index is not partitioned. | G |
| IXNAME | VARCHAR(18) NOT NULL | Name of the index. | G |
| IXCREATOR | CHAR(8) NOT NULL | Authorization ID of the owner of the index. | G |
| PQTY | INTEGER NOT NULL | Primary space allocation in units of 4KB storage blocks. Zero if a storage group is not used. | G |
| SECQTYI | INTEGER NOT NULL | Secondary space allocation in units of 4KB storage. If a storage group is not used, the value is 0. | G |
| LEAFDIST | INTEGER NOT NULL WITH DEFAULT -1 |
100 times the average number of leaf pages between successive active leaf pages of the index. The value is -1 if statistics have not been gathered. | S |
| 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 |
| 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 |
| FAROFFPOSF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Number of referred to rows far from optimal position because of an insert into a full page. The value is -1 if statistics have not been gathered. The column is not applicable for an index on an auxiliary table. | S |
| NEAROFFPOSF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Number of referred to rows near, but not at optimal position, because of an insert into a full page. Not applicable for an index on an auxiliary table. The value is -1 if statistics have not been gathered. | S |
| CARDF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Number of keys in the index that refer to data rows or LOBs. The value is -1 if statistics have not been gathered. | S |
| EXTENTS | INTEGER NOT NULL WITH DEFAULT -1 |
Number of data set extents. The value is -1 if statistics have not been gathered. This value is only for the last DSNUM for the # object. |
G |
| PSEUDO_DEL_ENT | INTEGER NOT NULL WITH DEFAULT -1 |
Number of psuedo deleted entries. The value is -1 if statistics have not been gathered. | G |
| DSNUM | INTEGER NOT NULL WITH DEFAULT -1 |
Data set number within the table space. For partitioned index spaces, this value corresponds to the partition number for a single partition copy, or 0 for a copy of an entire partitioned index space. 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 |
| LEAFNEAR | INTEGER NOT NULL WITH DEFAULT -1 |
Number of leaf pages physically near previous leaf page for successive active leaf pages. The value is -1 if statistics have not been gathered. This is an updatable column. | S |
| LEAFFAR | INTEGER NOT NULL WITH DEFAULT -1 |
Number of leaf pages located physically far away from previous leaf pages for successive (active leaf) pages accessed in an index scan. The alue is -1 if statistics have not been gathered. This is an updatable column. | S |