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
| 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)