|
SYSIBM.SYSTABSTATS www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains one row for each partition of a partitioned table space.
| Nome da coluna | Tipo de dados | Descrição | Uso |
| CARD | INTEGER NOT NULL | Total number of rows in the partition. This is an updatable column. | S |
| NPAGES | INTEGER NOT NULL | Total number of pages on which rows of the partition appear. This is an updatable column. | S |
| PCTPAGES | SMALLINT NOT NULL | Percentage of total active pages in the partition that contain rows of the table. This is an updatable column. | S |
| NACTIVE | INTEGER NOT NULL | Number of active pages in the partition. This is an updatable column. | S |
| PCTROWCOMP | SMALLINT NOT NULL | Percentage of rows compressed within the total number of active rows in the partition. This includes any row in a table space that is defined with COMPRESS YES. This is an updatable column. | S |
| STATSTIME | TIMESTAMP NOT NULL | If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. This is an updatable column. | G |
| IBMREQD | CHAR(1) NOT NULL | Whether the row came from the basic machine-readable material (MRM)
tape. N No Y Yes |
G |
| DBNAME | CHAR(8) NOT NULL | Database that contains the table space named in TSNAME. | G |
| TSNAME | CHAR(8) NOT NULL | Table space that contains the table. | G |
| PARTITION> | SMALLINT NOT NULL | Partition number of the table space that contains the table. | G |
| OWNER | CHAR(8) NOT NULL | Authorization ID of the owner of the table. | G |
| NAME | VARCHAR(18) NOT NULL | Name of the table. | G |