SYSIQJOINIXTABLE system table

CREATE TABLE SYS.SYSIQJOINIXTABLE (
	table_id UNSIGNED INT NOT NULL,
	joinindex_id UNSIGNED INT NOT NULL,
	active UNSIGNED INT NOT NULL,
	PRIMARY KEY ( table_id, joinindex_id )
)

The rows of SYSIQJOINIXTABLE describe the tables that explicitly participate in a join index.

table_id Corresponds to a table value in SYSTABLE that is included in a join operation.

joinindex_id Corresponds to a join index value in SYSIQJOININDEX.

active Defines the number of times the table is used in the join index.