A tabela SYSCONTEXT contém uma linha para cada contexto confiável.
O esquema é SYSIBM.
The SYSCONTEXT table contains one row for each trusted context.
The schema is SYSIBM.
| 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 |
| AUTHENTICATEPUBLIC |
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 |
| DEFAULTSECURITYLABEL |
VARCHAR(24)
NOT NULL |
Name of the context default RACF security label. |
G |
| SYS_START |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN |
Reserved for future IBM® use. |
G |
| SYS_END |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END |
Reserved for future IBM use. |
G |
| TRANS_START |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID |
Reserved for future IBM use. |
G |
