SQL - SYSIBM.SYSCTXTTRUSTATTRS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSCTXTTRUSTATTRS
Db2 for z/OS 12.0.0

A tabela SYSCTXTTRUSTATTRS contém uma linha para cada lista de atributos de um determinado contexto confiável.
O esquema é SYSIBM.

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

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 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.

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


© Copyright IBM Corp.