Use alter
connection or configure
replication server to
set the values of the bulk copy-in parameters.
Use:
alter
connection to change the bulk copy-in connection parameters
at the connection level:
alter connection to dataserver.database
set {dsi_bulk_copy | dsi_bulk_threshold} to value
configure
replication server to change the server defaults:
configure replication server
set {dsi_bulk_copy | dsi_bulk_threshold} to value
To
check the values of dsi_bulk_copy and dsi_bulk_threshold,
use admin
config.
When
dsi_bulk_copy is
on,
SQT counts the number of
consecutive
insert statements on the same table
that a transaction contains. If this number reaches the
dsi_bulk_threshold,
DSI:
Bulk copies the data to Adaptive Server until DSI reaches a command that is not insert or
that belongs to a different replicate table.
Continues with the rest of the commands in the transaction.
Adaptive Server sends the result of bulk copy-in at the end
of the bulk operation, when it is successful, or at the point of
failure.
Note: The DSI implementation
of bulk copy-in supports multistatement transactions,
allowing DSI to perform bulk
copy-in even if a transaction contains commands that are not part
of the bulk copy.