Tabelas SYSIBM

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

Nome da coluna	Tipo de dados	Descrição	Uso
PARTITION	SMALLINT NOT NULL	Partition number; 0 if table space is not partitioned.	G
TSNAME	CHAR(8) NOT NULL	Name of the table space.	G
DBNAME	CHAR(8) NOT NULL	Name of the database containing the table space.	G
IXNAME	VARCHAR(8) NOT NULL	Name of the partitioned index. This column is blank if the table space is not partitioned.	G
IXCREATOR	CHAR(8) NOT NULL	Authorization ID of the owner of the partitioned index. This column is blank if the table space is not partitioned.	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 TABLESPACE with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. PQTY is based on a value of PRIQTY in the appropriate CREATE or ALTER TABLESPACE statement. Unlike PQTY, however, PRIQTY asks for space in 1KB units.	G
SQTY	SMALLINT NOT NULL	Secondary space allocation in units of 4KB blocks. For user-managed data sets, the value is set to the secondary space allocation only if RUNSTATS TABLESPACE with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. SQTY is based on a value of SECQTY in the appropriate CREATE or ALTER TABLESPACE statement. Unlike SQTY, however, SECQTY asks for space in 1KB units.	G
STORTYPE	CHAR(1) NOT NULL	Type of storage allocation: E Explicit (storage group not used) I Implicit (storage group used)	G
STORNAME	CHAR(8) NOT NULL	Name of storage group used for space allocation. Blank if storage group not used.	G
VCATNAME	CHAR(8) NOT NULL	Name of integrated catalog facility catalog used for space allocation.	G
CARD	INTEGER NOT NULL	Number of rows in the table space or partition. The value is 2147483647 if the number of rows is greater than or equal to 2147483647. The value is -1 if statistics have not been gathered.	G
FARINDREF	INTEGER NOT NULL	Number of rows that have been relocated far from their original page. The value is -1 if statistics have not been gathered.	G
NEARINDREF	INTEGER NOT NULL	Number of rows that have been relocated near their original page. The value is -1 if statistics have not been gathered.	S
PERCACTIVE	SMALLINT NOT NULL	Percentage of space occupied by rows of data from active tables. The value is -1 if statistics have not been gathered.	S
PERCDROP	SMALLINT NOT NULL	Percentage of space occupied by rows of dropped tables. The value is -1 if statistics have not been gathered. 0 for segmented table spaces.	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	The high value of the partition in external format. 0 if the table space is not partitioned.	G
FREEPAGE	SMALLINT NOT NULL	The number of pages loaded before a page is left as free space.	G
PCTFREE	SMALLINT NOT NULL	The percentage of each page left as free space.	G
CHECKFLAG	CHAR(1) NOT NULL WITH DEFAULT	C the table space partition is in a check pending state and there are rows in the table that can violate referential constraints, table check constraints, or both. blank The table space is not a partition, or does not contain rows that may violate referential constraints, table check constraints, or both.	G
	CHAR(4) NOT NULL WITH DEFAULT FOR BIT DATA	Not used	N
SPACE	CHAR(8) NOT NULL	Number of kilobytes of DASD storage allocated to the table 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 table space is related to a storage group. The value is updated by RUNSTATS if the utility is executed as RUNSTATS TABLESPACE with UPDATE(ALL) or UPDATE(SPACE).	G
COMPRESS	CHAR(1) NOT NULL WITH DEFAULT	Indicates the following: ° For a table space partition, whether the COMPRESS attribute for the partition is YES. ° For a nonpartitioned table space, whether the COMPRESS attribute is YES for the table space. Values for the column can be: blank No compression Y Compression is defined for the table space	G
PAGESAVE	SMALLINT NOT NULL WITH DEFAULT	Percentage of pages saved in the table space or partition as a result of defining the table space with COMPRESS YES or other compression routines. For example, a value of 25 indicates a savings of 25 percent, so that the pages required are only 75 percent of what would be required without data compression. The calculation includes overhead bytes for each row, the bytes required for dictionary, and the bytes required for the current FREEPAGE and PCTFREE specification for the table space or partition. This calculation is based on an average row length, and the result varies depending on the actual lengths of the rows. The value is 0 if there are no savings from using data compression, or if statistics have not been gathered. The value can be negative, if for example, data compression causes an increase in the number of pages in the data set.	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
GBPCACHE	CHAR(1) NOT NULL WITH DEFAULT	Group buffer pool cache option specified for this table space or table space 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
CHECKRID5B	CHAR(5) NOT NULL WITH DEFAULT	Blank if the table or partition is not in a check pending state (CHECKFLAG is blank), or if the table space is not partitioned. Otherwise, the RID of the first row of the table space partition that can violate referential constraints, table check constraints, or both; or the value is X'0000000000', indicating that any row can violate referential constraints.	G