Menu principal                 [Fechar]
Introdução
Divisões
Identification Division
Environment Division
Data Division
Procedure Division
Comandos CICS
VSAM - File Status
Quadros importantes
SQL - Structured Query Language
Outros programas
Rotinas prontas
Palavras reservadas
Introdução ao Oracle
Sites de busca
Sites interessantes
Meu e-mail
SYSIBM.SYSINDEXPART
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

Contains one row for each nonpartitioned index and one row for each partition of a partitioned index.

Nome da coluna Tipo de dados Descrição Uso
 PARTITION  SMALLINT NOT NULL  Partition number; 0 if index is not partitioned. G
 IXNAME  VARCHAR(18) NOT NULL  Name of the index. G
 IXCREATOR  VARCHAR(8) NOT NULL  Authorization ID of the owner of the index. G
 PQTY  INTEGER NOT NULL  Primary space allocation in units of 4KB storage blocks.
 For user-managed data sets, the value is set to the primary space  allocation only if RUNSTATS INDEX with UPDATE(ALL) or UPDATE  (SPACE) is executed; otherwise, the value is zero.		 G
 SQTY  SMALLINT NOT NULL  Secondary space allocation in units of 4KB storage blocks.
 For user-managed data sets, the value is set to the secondary space  allocation only if RUNSTATS INDEX with UPDATE(ALL) or UPDATE  (SPACE) is executed; otherwise, the value is zero.		 G
 STORTYPE  CHAR(1) NOT NULL  Type of storage allocation:

 E   explicit and STORNAME names an integrated catalog facility catalog
 I    implicit and STORNAME names a storage group		 G
 STORNAME  CHAR(8) NOT NULL  Name of storage group or integrated catalog facility catalog used for  space allocation. G
 VCATNAME  CHAR(8) NOT NULL  Name of integrated catalog facility catalog used for space allocation. G
   INTEGER NOT NULL  Not used S
   INTEGER NOT NULL  Not used S
 LEAFDIST  INTEGER NOT NULL  100 times the average number of leaf pages between successive active  leaf pages of the index. The value is -1 if statistics have not been  gathered. G
   INTEGER NOT NULL  Not used S
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM)  tape:

 N    No
 Y    Yes 		G
 LIMITKEY  VARCHAR(512) NOT NULL FOR BIT DATA
  The high value of the limit key of the partition in an internal format. 0 if  the index is not partitioned.

 If any column of the key has a field procedure, the internal format is the  encoded form of the value.		 S
 FREEPAGE  SMALLINT NOT NULL  The number of pages that are loaded before a page is left as free space. G
 PCTFREE  SMALLINT NOT NULL  The percentage of each subpage or nonleaf page that is left as free  space. G
 SPACE  INTEGER NOT NULL
 WITH DEFAULT		  Number of kilobytes of DASD storage allocated to the index space  partition, as determined by the last execution of the STOSPACE or  RUNSTATS utility.
 The value is 0 if STOSPACE or RUNSTATS has not been run. The value is  updated by STOSPACE if the index is related to a storage group. The  value is updated by RUNSTATS if the utility is executed as RUNSTATS  INDEX with UPDATE(ALL) or UPDATE(SPACE).		 G
 STATSTIME  TIMESTAMP NOT NULL
 WITH DEFAULT		  If RUNSTATS updated the statistics, the date and time when the last  invocation of RUNSTATS updated the statistics.
 The default value is '0001-01-01.00.00.00.000000'.		 G
   CHAR(1) NOT NULL  Not used N
 GBPCACHE  CHAR(1) NOT NULL
 WITH DEFAULT		  Group buffer pool cache option specified for this index or index  partition.

 blank    Only changed pages are cached in the group buffer pool.
 A            Changed and unchanged pages are cached in the group buffer                pool.		 G
 FAROFFPOSF  FLOAT NOT NULL
 WITH DEFAULT -1		  Number of referred to rows far from optimal position because of an insert  into a full page. The value is -1 if statistics have not been gathered. S
 NEAROFFPOSF  FLOAT NOT NULL
 WITH DEFAULT -1		  Number of referred to rows near, but not at optimal position, because of  an insert into a full page. S
 CARDF  FLOAT NOT NULL
 WITH DEFAULT -1		  Number of rows referred to by the index or partition. The value is -1 if  statistics have not been gathered. S