|
SYSIBM.SYSCOLDIST_HIST www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains rows from SYSCOLDIST. 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 |
| STATSTIME | TIMESTAMP NOT NULL | If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. | G |
| TBOWNER | CHAR(8) NOT NULL | Authorization ID of the owner of the table that contains the column. | G |
| TBNAME | VARCHAR(18) NOT NULL | Name of the table that contains the column. | G |
| NAME | VARCHAR(18) NOT NULL | Name of the column. If NUMCOLUMNS is greater than 1, this name identifies the first column name of the set of columns associated with the statistics. | G |
| COLVALUE | VARCHAR(255) NOT NULL FOR BIT DATA |
Contains the data of a frequently occurring value. Statistics are not collected for an index on a ROWID column. If the value has a non-character data type, the data might not be printable. | S |
| TYPE | CHAR(1) NOT NULL WITH DEFAULT 'F' |
The type of statistics gathered: C Cardinality F Frequent value |
G |
| CARDF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Number of distinct values for the column group. This number is valid only for TYPE C statistics. The value is -1 if statistics have not been gathered. |
S |
| COLGROUPCOLNO | VARCHAR(254) NOT NULL | Identifies the set of columns associated with the statistics. If the statistics are only associated with a single column, the field contains a zero length. Otherwise, the field is an array of SMALLINT column numbers with a dimension equal to the value in NUMCOLUMNS. | S |
| NUMCOLUMNS | SMALLINT NOT NULL WITH DEFAULT 1 |
Identifies the number of columns associated with the statistics. | G |
| FREQUENCYF | FLOAT(8) NOT NULL DEFAULT -1 | Gives the percentage of rows in the table with the value specified in COLVALUE when the number is multiplied by 100. For example, a value of 1 indicates 100%. A value of .153 indicates 15.3%. Statistics are not collected for an index on a ROWID column. The value is -1 if statistics have not been gathered. | G |
| IBMREQD | CHAR(1) NOT NULL 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 |