SYSIQTAB System View

Presents group information from ISYSIQTAB in a readable format. Each row in the SYSIQTAB view describes an IQ table.

ALTER VIEW "SYS"."SYSIQTAB"
as select * from SYS.ISYSIQTAB

Note: This view replaces the deprecated system view SYSIQTABLE.

Column name	Column type	Description
table_id	unsigned int	Each table is assigned a unique number (the table number) that is the primary key.
block_map	hs_blockmapidentity	For internal use.
block_map_size	unsigned int	For internal use.
vdo	hs_vdoidentity	For internal use.
vdoid_size	unsigned int	For internal use.
info_location	hs_vdorecid	Not used. Always zero.
info_recid_size	unsigned int	Not used. Always zero.
info_location_size	unsigned int	Not used. Always zero.
commit_txn_id	unsigned bigint	For internal use.
txn_id	unsigned bigint	For internal use.
update_time	timestamp	Last date and time the IQ table was modified.
is_rlv	char(1)	'T' – RLV storage is enabled on the table; 'F' – RLV storage is not enabled on the table.

Constraints on underlying system table:

Primary key (table_id)