SYSIQJOINIDX System View

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

unsigned bigint

For internal use.

txn_id

unsigned bigint

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.