SYSIBM.SYSCONTEXT table

The SYSIBM.SYSCONTEXT table contains one row for each trusted context.

Column name Data type Description Use
NAME
VARCHAR(128)
NOT NULL
 Name of the trusted context. G
CONTEXTID
INTEGER
NOT NULL
GENERATED
ALWAYS AS
IDENTITY
 Internal context ID. G
DEFINER
VARCHAR(128)
NOT NULL
 Authorization ID or role that defined the trusted context. G
DEFINERTYPE
CHAR(1)
NOT NULL
 The type of the definer:
L
Role
blank
Authorization ID
 G
SYSTEMAUTHID
VARCHAR(128)
NOT NULL
 The DB2® primary authorization ID that is used to establish the connection. For remote requests, SYSTEMAUTHID is derived from the system user ID that is provided by an external entity, such as a middleware server.
For local requests, SYSTEMAUTHID depends on one of the following sources of the address space:
BATCH
USER parameter on JOB statement
RRSAF
USER parameter on JOB statement or RACF® user
TSO
TSO logon ID
 G
DEFAULTROLE
VARCHAR(128)
NOT NULL
 Name of the trusted context default role. G
OBJECTOWNERTYPE
CHAR(1)
NOT NULL
 Whether the ROLE AS OBJECT OWNER AND QUALIFIER clause is specified in the definition of this trusted context:
L
ROLE AS OBJECT OWNER AND QUALIFIER is specified. A role owns any object created in the trusted context. The role is used as the default for the CURRENT SCHEMA special register. The role is included in the SQL PATH.
blank
ROLE AS OBJECT OWNER is not specified. An authorization ID owns any object created in the trusted context.
 G
CREATEDTS
TIMESTAMP
NOT NULL
 The time when the trusted context is created. G
ALTEREDTS
TIMESTAMP
NOT NULL
 The time when the trusted context is last altered. G
ENABLED
CHAR(1)
NOT NULL
 The status of the trusted context:
Y
Enabled
N
Disabled
 G
ALLOWPUBLIC
CHAR(1)
NOT NULL
 Whether the connection is allowed to be reused for PUBLIC:
Y
Connection reuse is allowed
N
Connection reuse is not allowed
 G
AUTHENTICATE-
PUBLIC
CHAR(1)
NOT NULL
 Whether authentication is required for PUBLIC when ALLOWPUBLIC is Y:
Y
Authentication token is required for PUBLIC. 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
RELCREATED
CHAR(1)
NOT NULL
 The release of DB2 that is used to create the object. See Release dependency indicators for the values. G
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.

The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead.

 G
REMARKS
VARCHAR(762)
NOT NULL
 A character string that is provided using the COMMENT statement. G
DEFAULT-
SECURITYLABEL
VARCHAR(24)
NOT NULL
 Name of the context default RACF security label. G