Password, Retries, Rowsetsize – HP Neoview Release 2.5 Software User Manual
Page 63: Sorted, Password retries rowsetsize sorted
For a Neoview SQL extract operation:
•
Transporter internally limits the maximum value of parallelstreams to the number of
CPUs on the Neoview system.
•
If this option is not specified, Transporter sets parallelstreams to the number of CPUs
on the Neoview system divided by four.
Although Transporter does not impose many requirements on the value of parallelstreams,
the optimal value to prevent load imbalances is one in which the number of partitions is
distributed equally across the number of parallel streams, with no one stream handling a difference
of two partitions more than another stream.
password
password = "password" | ${referencename | $E{referencename}
This option is required.
password
specifies the password to use when connecting to a JDBC, ODBC, or JMS data source.
•
password
specifies a plain-text password.
•
${referencename}
refers to a plain-text password in the plain property file. Transporter
automatically substitutes the corresponding password when it processes the control file.
•
$E{referencename}
refers to an encrypted password in the encrypted property file.
Transporter automatically substitutes the corresponding decrypted plain-text password
when it processes the control file.
The maximum length of any plain text password is 64 characters.
For more information, see
retries
retries = number
The default value is 3.
This option specifies how many retry attempts Transporter should make to establish a database
connection, open a JMS source, or open a named pipe on behalf of a job.
retries = number
can be zero or a positive integer.
The
option specifies how long to wait on each attempt.
rowsetsize
rowsetsize = number_of_records
The value must be an integer in the range from 1 to 100000.
This option specifies the number of records read and processed as a batch from input data files.
If this option is not specified, Transporter chooses an optimized value based on the Neoview
SQL table or query.
sorted
sorted = true | false
The default is false.
For a load operation, this option specifies whether source files are sorted by the table’s primary
key. Transporter can improve performance and parallelism of certain database operations when
data is sorted by the primary key.
Errors can be returned if sorted is true and input data is not properly sorted.
password
63