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.

join_id

unsigned int

For internal use.

update_time

timestamp

Last date and time the IQ table was modified.

Constraints on underlying system table:

Primary key (table_id)

Related reference
SYSIQTABLE System View (Deprecated)