Host table

The Host table contains details of engine systems where jobs are started, and of remote nodes used by an engine system to distribute parallel jobs.

The HostDetail table contains information about the available system resources of every engine system and compute node in the Host table.
Table 1. Host table
Column name Column type code Description
HostName 80 The name of the DataStage engine or remote system. The name is obtained by executing the hostname command or from the DS_HOSTNAME_ALIAS environment variable if it is set. The name is normalized to uppercase.
InstallationDir 255 The location of the DSODB directory associated with an installation of the DataStage engine on the host, which can be used to distinguish between multiple installations of IBM® InfoSphere® Information Server on the same system.

If this column is a string consisting of a single hyphen (-), the host represents a remote node rather than an engine node.

The combination of HostName and InstallationDir is unique.

CreatedTimestamp Tim The time that this row was inserted into the table.
MonStartTimestamp Tim The latest time that an EngMonApp process started and identified this row as the one representing its own installation.