SYSIQJOINIDX system view

Presents group information from ISYSIQJOINIDX in a readable format. Each row in the SYSIQJOINIDX view describes an IQ join index.

NoteThis view replaces the deprecated system view SYSIQJOININDEX.

Column name

Column type

Description

joinindex_id

unsigned int

Each join index is assigned a unique number that is the primary key.

jvt_id

unsigned int

For internal use.

dbspace_id

smallint

ID of the dbspace.

joinindex_name

char(128)

Defines the name of the join index.

joinindex_type

char(12)

For internal use.

creator

unsigned int

The number of the user that created the join index.

join_info_location

hs_vdorecid

For internal use.

join_info_loc_size

unsigned int

For internal use.

join_info_size

unsigned int

For internal use.

block_map

hs_blockmapidentity

For internal use.

block_map_size

unsigned int

For internal use.

vdo

hs_vdoidentity

For internal use.

vdo_size

unsigned_int

For internal use.

commit_txn_id

xact_id

For internal use.

txn_id

xact_id

For internal use.

valid

char(1)

Indicates whether this join index needs to be synchronized. Y indicates that it does not require synchronization, N indicates that it does require synchronization.

Constraints on underlying system table

Primary key (joinindex_id)

Foreign key (jvt_id) references SYS.ISYSTAB

Foreign key (dbspace_id) references SYS.ISYSDBSPACE

Foreign key (creator) references SYS.ISYSUSER

Unique (jvt_id, commit_txn_id, txn_id)