Tabelas SYSIBM - SYSIBM.SYSAUXRELS

SYSIBM.SYSAUXRELS

Contém uma linha para cada tabela auxiliar criada para uma coluna LOB.
Um espaço de tabela base particionado deve ter uma tabela auxiliar para cada partição de cada coluna LOB.

Contains one row for each auxiliary table created for a LOB column.
A base table space that is partitioned must have one auxiliary table for each partition of each LOB column.

Nome da coluna	Tipo do dado	Descrição	Uso
TBOWNER	CHAR(8) NOT NULL	Authorization ID of the owner of the base table.	G
TBNAME	VARCHAR(18) NOT NULL	Name of the base table.	G
COLNAME	VARCHAR(18) NOT NULL	Name of the LOB column in the base table.	G
PARTITION	SMALLINT NOT NULL	Partition number if the base table space is partitioned. Otherwise, the value is 0.	G
AUXTBOWNER	CHAR(8) NOT NULL	Authorization ID of the owner of the auxiliary table.	G
AUXTBNAME	VARCHAR(18) NOT NULL	Name of the auxiliary table.	G
AUXRELOBID	INTEGER NOT NULL	Internal identifier of the relationship between the base table and the auxiliary table.	S
IBMREQD	CHAR(1) NOT NULL	A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators in topic D.0.	G