Description: Allows multiple IP addresses to be specified for a given LOCATION. Insert rows into this table when you want to define a remote DB2 data sharing group. The same value for the IPADDR column cannot appear in both the SYSIBM IPNAMES table and the SYSIBM.IPLIST table. Rows in this table can be inserted, updated, and deleted.
Tablespace: SYSDDF
Indexes(Fields):
DSNDUX01(LINKNAME.IPADDR)
| Column name | Description | Data type |
|---|---|---|
| LINKNAME | 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. | NOT NULL |
| IPADDR | This column contains the IP 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:* If IPADDR contains a left justified character string containing four numeric values delimited by decimal points, DB2 assumes the value is an IP address in dotted decimal format. For example, '123.456.78.91' would be interpreted as a dotted decimal IP address.
|
NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL WITH DEFAULT 'N' |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).