ALTER VIEW "SYS"."SYSIQTAB" as select * from SYS.ISYSIQTAB
Presents group information from ISYSIQTAB in a readable format. Each row in the SYSIQTAB view describes an IQ table.
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 |
xact_id |
For internal use. |
txn_id |
xact_id |
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)
