Teamsize, Tenacity, Timeout – HP Neoview Release 2.5 Software User Manual

Page 65: Truncate, Teamsize tenacity timeout, Truncate url

If this option is not specified, Transporter determines an optimized value based on heap size
(memory allocated), table being loaded, number of columns, types of columns, and the server
memory utilization of the client.

teamsize

teamsize = 1 | 2 | 4

The default is 1.

This option specifies the number of Neoview server processes, or connections, that you want to
have insert data on a single parallel stream operating on a set of partitions.

The total number of data connections established by Transporter is determined by multiplying
teamsize

“parallelstreams” (page 62)

To enable multi-session side-tree inserts for a specific load job, set teamsize to 2 or 4.

This option does not apply to extract jobs.

tenacity

tenacity = number_of_seconds

The default is 15 seconds.

This option specifies how long, in seconds, Transporter should wait between attempts to establish
a database connection, open a JMS source, or open a named pipe before retrying.

number_of_seconds

can be zero or a positive integer.

The

“retries” (page 63)

option specifies how many retry attempts should be made for a given

resource.

timeout

timeout = number_of_seconds

The default value is 60 seconds.

After a named pipe or JMS source has been successfully opened, this option specifies how long
Transporter waits, in seconds, for a read or write operation to complete before timing out and
returning an error.

number_of_seconds

can be zero or a positive integer.

truncate

truncate = "true" | "false"

The default is “false” (do not delete data from the target).

This option specifies whether Transporter should truncate target tables (for a load operation) or
target data files (for an extract operation) before job processing begins.

true

means Transporter will delete all data from the target table or file before job processing

begins.

false

means Transporter will not delete data from the target before job processing begins.

For a load operation where the

“operation” (page 62)

is “insert”, if the

“noaudit” (page 61)

option is set to true then truncate must also be set to true otherwise an error is returned.

For a single job group, truncate is performed only once per unique target.

url

url = "urlname"

This option specifies an access point for:

teamsize