SQL - SYSIBM.SYSCOLSTATS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSCOLSTATS
Contains partition statistics for selected columns.
For each column, a row exists for each partition in the table.
Rows are inserted when RUNSTATS collects either indexed column statistics or non-indexed column statistics for a partitioned table space.
No row is inserted if the table space is nonpartitioned.

Nome da coluna Tipo de dado Descrição Uso
 HIGHKEY  CHAR(8) NOT NULL FOR BIT DATA  Highest value of the column within the partition. Blank if statistics have not  been gathered. If the column has a non-character data type, the data might not  be printable. This is an updatable column.  S
 HIGH2KEY  CHAR(8) NOT NULL FOR BIT DATA  Second highest value of the column within the partition. Blank if statistics have  not been gathered. If the column has a non-character data type, the data might  not be printable.  S
 LOWKEY  CHAR(8) NOT NULL FOR BIT DATA  Lowest value of the column within the partition. Blank if statistics have not  been gathered. If the column has a non-character data type, the data might not  be printable. This is an updatable column.  S
 LOW2KEY  CHAR(8) NOT NULL FOR BIT DATA  Second lowest value of the column within the partition. Blank if statistics have  not been gathered. If the column has a non-character data type, the data might  not be printable. This is an updatable column.  S
   INTEGER NOT NULL  Number of distinct column values in the partition. 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. If the value is '0001-01-02.00.00.00.000000',  RUNSTATS should be run to update the statistics before they are used. 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
 PARTITION  SMALLINT NOT NULL  Partition number for the table space containing the table in which the column  is defined.  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.  G
 COLCARDDATA  VARCHAR(1000) NOT NULL FOR BIT  DATA  Internal use only  I

© Copyright IBM Corp.