|
SYSIBM.SYSTABLES_HIST www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains rows from SYSTABLES. 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 table, view, or alias. | G |
| CREATOR | CHAR(8) NOT NULL | Authorization ID of the owner of the table, view, or alias. | G |
| DBNAME | CHAR(8) NOT NULL | For a table, or a view of tables, the name of the database that contains the table space named in TSNAME. For a temporary table, an alias, or a view of a view, the value is DSNDB06. | G |
| TSNAME | CHAR(8) NOT NULL | For a table, or a view of one table, the name of the table space that contains the table. For a view of more than one table, the name of a table space that contains one of the tables. For a temporary table, the value is SYSPKAGE. For a view of a view, the value is SYSVIEWS. For an alias, it is SYSDBAUT. | G |
| COLCOUNT | SMALLINT NOT NULL | Number of columns in the table or view. The value is 0 if the row describes an alias. | G |
| PCTPAGES | SMALLINT NOT NULL WITH DEFAULT -1 |
Percentage of active table space pages that contain rows of the table. A page is termed active if it is formatted for rows, regardless of whether it contains any. If the table space is segmented, the percentage is based on the number of active pages in the set of segments assigned to the table. The value is -1 if statistics have not been gathered, or the row describes a view, alias, temporary table, or auxiliary table. | S |
| PCTROWCOMP | SMALLINT NOT NULL WITH DEFAULT -1 |
Percentage of rows compressed within the total number of active rows in the table. This includes any row in a table space that is defined with COMPRESS YES. The value is -1 if statistics have not been gathered, or the row describes a view, alias, temporary table, or auxiliary table. | G |
| CARDF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Total number of rows in the table or total number of LOBs in an auxiliary table. The value is -1 if statistics have not been gathered or the row describes a view, alias, or temporary table. | S |
| NPAGESF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Total number of pages on which rows of the partition appear. The value is -1 if statistics have not been gathered. | S |
| AVGROWLEN | INTEGER NOT NULL WITH DEFAULT -1 |
Average row length of the table specified in the table space. The value is -1 if statistics have not been gathered. | G |
| SPACEF | FLOAT(8) NOT NULL WITH DEFAULT -1 |
Kilobytes of DASD storage. The value is -1 if statistics have not been gathered. This is an updatable column. | 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 |