|
SYSIBM.SYSLOBSTATS www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
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 |