Operation, Parallel, Parallelstreams – HP Neoview Release 2.4 Software User Manual
Page 57: Password, Operation parallel parallelstreams password
operation
operation = "insert" | "update" | "upsert" | "delete"
The default is “insert”.
For a load operation, this option specifies the type of Neoview SQL operation to be performed:
•
“insert”
– inserts data into a Neoview SQL table
•
“update”
– updates data in a Neoview SQL table
•
“upsert”
– updates data in a Neoview SQL table if the data exists, otherwise inserts data
•
"delete"
— deletes data from a Neoview SQL table, if the data matching the WHERE
clause exists; otherwise, does nothing
This option is ignored for extract operations.
"upsert"
is not supported on tables with triggers enabled.
parallel
parallel = "true" | "false"
“true”
— all job entries for load jobs execute in parallel
“false”
— all job entries of a given job execute serially
The default is “false”.
This option does not apply to extract jobs. All extract job entries are executed serially.
parallelstreams
parallelstreams = number
This option specifies the number of data connections Transporter establishes for accessing the
Neoview database for extract jobs. Whereas for load jobs, parallelstreams in combination with
(parallelstreams * teamsize) specifies the number of data
connections Transporter establishes for accessing the Neoview database.
number
must be:
•
An integer greater than or equal to one.
•
A power of two if set to a value greater than one.
For a load operation or a TABLE extract operation:
•
Transporter internally limits the maximum value of parallelstreams to the number of
partitions in the system divided by four, to the nearest power of two.
•
If this option is not specified, Transporter sets parallelstreams to the number of partitions
on the Neoview system divided by four, to the nearest power of two.
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, to the nearest power of two.
password
password = "password" | ${referencename | $E{referencename}
This option is required.
operation
57