Discovery node table (DISCOVERY_NODE)

The following table describes the data fields in the Discovery Node Table.

Element Type Description
ANOS400 smallint 0=Node is not i5/OS.

1=Node is i5/OS.

API_PORT varchar API port value.
COMMENTS text User description for node.
CONNECTION_TIMEOUT bigint Internal field used for Node Discovery.
DB_LIBRARY varchar Sterling Connect:Direct® for i5/OS database library name.
DISCOVERED_TIME varchar Time node was discovered.
DISCOVERY_START_TM varchar Discovery start date range value.
DISCOVERY_STOP_TM varchar Discovery end date range value.
DTF_ADDRESS varchar Server host address.
DTF_PORT varchar Server port value.
ENABLED smallint 0=Disabled

1=Enabled

FROM_NETMAP smallint 0=Not found in Netmap.

1=Found in Netmap.

FROM_STATS smallint 0=Not found in statistics.

1=Found in statistics.

HOST_NAME varchar Host name for server.
ID bigint For internal use.
IGNORED smallint For discovered nodes:

1=Found in Mylist.

0=Found in Discovered list.

LAST_DSCVRY_ATTEMPT varchar Time of last discovery attempt.
LST_SCCSSFL_DSCVRY varchar Time of last successful discovery attempt.
MESSAGE_KEY varchar Message.
MESSAGE_PARAMETERS text Values used to construct message text.
MESSAGE_PRIORITY bigint Priority of message.
NET_MAP_ENTRIES bigint Number of Netmap entries found.
NODE_NAME varchar Name of server.
OPERATING_SYSTEM varchar Server operating system.
PARTNERS bigint Number of partner nodes found.
PASSWORD text Password for API connection.
PROCESSES bigint Number of Processes found to have run during Discovery.
PROTOCOL varchar Internal field for Node Discovery.
RETURN_CODE bigint Return code for Discovery.
SERVER_LICENSE text Server license text.
SERVICE_ID varchar Node or alias name.
SOURCE_PORT varchar Source port range to use for API connection.
SRVR_LCNS_EXPRTN_D varchar Server license expiration date.
TYPE varchar Type of node.

E=Explorer node

D=Discovered node

USER_ID varchar User ID for API connection.