SYSCONTEXTAUTHIDS catalog table

The SYSCONTEXTAUTHIDS table contains one row for each authorization ID with which the trusted context can be used. The schema is SYSIBM.

Table 1. SYSIBM.SYSCONTEXTAUTHIDS table column descriptions
Column name Data type Description Use
CONTEXTID
INTEGER
NOT NULL
 The internal trusted context ID. G
AUTHID
VARCHAR(128)
NOT NULL
 The primary authorization ID that can reuse a connection. When RACF® is used, this is a RACF profile name that contains the primary authorization IDs that are permitted to use the connection in the identified trusted context. Start of changeA RACF profile name in this column has an ampersand (&) sign as the first character, to distinguish it from an authorization ID.End of change G
AUTHENTICATE
CHAR(1)
NOT NULL
 Whether authentication is required for the authorization ID in the AUTHID column:
Y
Authentication token is required for the authorization ID. For local requests, the token is the password. For remote requests, the token can be a password, a RACF passticket, or a Kerberos token
N
Authentication is not required
 G
ROLE
VARCHAR(128)
NOT NULL
 The role for the authorization ID in the AUTHID column. The role supersedes the default role that is defined for the trusted context. G
CREATEDTS
TIMESTAMP
NOT NULL
 The time when the authorization ID is added to the trusted context. 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
SECURITYLABEL
VARCHAR(24)
NOT NULL
 RACF security label for AUTHID. The security label supersedes the default security label, if any, that is defined for the context. 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