SYSCTXTTRUSTATTRS catalog table

The SYSCTXTTRUSTATTRS table contains one row for each list of attributes for a given trusted context. The schema is SYSIBM.

Table 1. SYSIBM.SYSCTXTTRUSTATTRS table column descriptions
Column name Data type Description Use
CONTEXTID
INTEGER
NOT NULL
The internal trusted context ID. G
NAME
VARCHAR(128)
NOT NULL
Name of the trust attribute. Possible values including the following attributes:
  • An IPv4 address is represented as a dotted decimal IP address. An example of an IPv4 address is '9.112.46.111'.
  • An IPv6 address is represented as a colon hexadecimal address. An example of an IPv6 address is '2001:0DB8:0000:0000:0008:0800:200C:417A', which can also be expressed in a compressed form as '2001:DB8::8:800:200C:417A'.
  • A domain name which is converted to an IP address by the domain name server where a resulting IPv4 or IPv6 address is determined.
  • A job or started task name for local applications. If the job name ends with *, any job name that matches the characters prior to * in the specified job name are considered for establishing the trusted connection.
  • A network access security zone name in the RACF® SERVAUTH class.
G
VALUE
VARCHAR(254)
NOT NULL
The value of the trust attribute. G
CREATEDTS
TIMESTAMP
NOT NULL
The time when the attribute is created. G
IBMREQD
CHAR(1)
NOT NULL
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

G
Start of changeSYS_STARTEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN
End of change
Start of changeReserved for future IBM® use.The row-begin column of the SYSTEM_TIME period, for system-period data versioning.End of change Start of changeGEnd of change
Start of changeSYS_ENDEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END
End of change
Start of changeReserved for future IBM use.The row-end column of the SYSTEM_TIME period, for system-period data versioning.End of change Start of changeGEnd of change
Start of changeTRANS_STARTEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID
End of change
Start of changeReserved for future IBM use. End of change Start of changeGEnd of change