SQL - SYSIBM.IPLIST - 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.IPLIST
Db2 for z/OS 12.0.0

A tabela IPLIST permite que vários endereços IP sejam especificados para um determinado LOCAL.
O esquema é SYSIBM.

Insira linhas nesta tabela quando quiser definir um grupo de compartilhamento de dados Db2 remoto.
O mesmo valor para a coluna IPADDR não pode aparecer na tabela IPNAMES e na tabela IPLIST.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.


Column name Data type Description Use
LINKNAME
VARCHAR(24)
NOT NULL
This column is associated with the value specified in the LINKNAME column in the SYSIBM.LOCATIONS table and the SYSIBM.IPNAMES table.
The values of the other columns in the SYSIBM.IPNAMES table apply to the server identified by the LINKNAME column in this row.
G
IPADDR
VARCHAR(254)
NOT NULL

This column contains an IPv4 or IPv6 address, or domain name of a remote TCP/IP host of the server.
If WLM Domain Name Server workload balancing is used, this column must contain the member specific domain name.
If Dynamic VIPA workload balancing is used, this column must contain the member specific Dynamic VIPA address.
The IPADDR column must be specified as follows:

  • An IPv4 address must be left justified and is represented as a dotted decimal address.
    For example, '123.456.78.912' would be interpreted as an IPv4 address.
  • An IPv6 address must be left justified and 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 compressed form as '2001:DB8::8:800:200C:417A'.
  • A domain name is converted to an IP address by the domain name server where a resulting IPv4 or IPv6 address is determined.
    An example of a domain name is 'stlmvs1.svl.ibm.com'.
G
IBMREQD
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. G


© Copyright IBM Corp.