Port

Port number for the data source to connect with the host.

The Port number for

DB2—no default

DB2 z/OS—446

Service Principal Name

This field is available only if you choose Kerberos authentication.

Use global temp space for temp tables

Option that can be used to improve performance when using this data source with the TDV data ship feature. This option would allow you to manage the temp tables created for the data source like any other temp table that you have defined in your source database.

Is dataship source

Indicates whether the physical data source might be used as a source of shipped tables to another data ship enabled data source

Lower bound/Upper bound

TDV uses Explain Plan to arrive at a numeric estimate of the cost of shipping data from a node to the Data Virtualizer. When the cost of shipping a federated query node falls between the limits of the Lowerbound and Upperbound, it is considered eligible for shipment so that it can be processed locally.

Is dataship target

Indicates whether the physical data source might be used to receive shipped tables from another data ship enabled data source.

Schema path for Temp Tables

A relative path to set the location of the temp tables on the data source. It is the name of a schema in the data source.

Temp Table Prefix

A character string addition to temporary table names so that they are recognized if they are needed.