SQL - SYSIBM.SYSLOBSTATS_HIST - 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_HIST
Contains rows from SYSLOBSTATS.
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  Timestamp of RUNSTATS statistics update.  G
 FREESPACE  INTEGER NOT NULL  Number of pages of free 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
 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


© Copyright IBM Corp.