SQL - SYSIBM.SYSLOBSTATS - 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.SYSLOBSTATS
Contains one row for each LOB table space.

Nome da coluna Tipo do dado Descrição Uso
 STATSTIME  TIMESTAMP NOT NULL  Timestamp of RUNSTATS statistics update.  G
 AVGSIZE  INTEGER NOT NULL  Average size of a LOB, measured in bytes, in the LOB table space.  S
 FREESPACE  INTEGER NOT NULL  Number of kilobytes of available space in the LOB table space.  S
 ORGRATIO  DECIMAL(5,2) NOT NULL  Ratio of organization in the LOB table space. A value of 1 indicates perfect  organization of the LOB table space. The greater the value exceeds 1, the more  disorganized the LOB table space.  S
 DBNAME  CHAR(8) NOT NULL  Name of the database that contains the LOB table space named in NAME.  G
 NAME  CHAR(8) NOT NULL  Name of the LOB table space.  G
 IBMREQD  CHAR(1) NOT NULL  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


© Copyright IBM Corp.