There are several configuration parameters on both the source and target SAP ASE server that affect the performance of the migration process.
Configuration parameters that affect the source SAP ASE server:
| Parameter | Description |
|---|---|
cis packet size | Should be equal to max page size of the
target SAP ASE server. |
number of user connections | Should be high enough to accommodate the migration of multiple tables simultaneously
according to the value of COPY_THREADS and INDEX_THREADS. |
max parallel degree | Should be set to a value that is larger than the largest number of partitions in a
single table. Data migration is done in parallel, and if max parallel
degree is not set to a value large enough to accommodate the partitioned
tables, the tables do not migrate. |
number of worker processes | Data migration for partitioned tables requires one worker thread per partition.
Therefore, if t partitioned tables with p partitions each are migrating simultaneously, configure a
total of t multiplied by p worker threads on the source SAP ASE server. |
cis bulk insert batch size | Controls the number of rows after which the data transfer transaction is
committed. The default value is 0. Using the default value is the safest way to ensure
data integrity while migrating data, but it can result in a large number of page and row
locks on the source SAP ASE server. To reduce the number of locks, increase this value. If
you increase the value of cis bulk insert batch size,
only a partial data migration completes if an error occurs during the process. In this
situation, manually truncate the target table and restart sybmigrate. |
cis bulk insert array size | Controls the number of rows that are copied in bulk at one time. The default is 50
rows per batch. For faster data migration, increase this value. If the table
contains text or image columns, the data is
transferred one row at a time, regardless of the value for cis bulk insert
array size. |
The following configuration parameters on the target SAP ASE server affect the performance of sybmigrate:
| Parameter | Description |
|---|---|
max network packet size | Should be set to a value that is at least equal to max page
size. |
number of user connections | Should be set to accommodate the migration of multiple tables in parallel and
partitioned tables. For parallel data transfer for partitioned tables, worker processes
are required on the source SAP ASE server, but user connections are required on the target
SAP ASE server. If you are migrating partitioned tables, set the
number of user connections on the target SAP ASE server to the same value as
number of worker processes on the source SAP ASE
server. |
number of sort buffers | The default value of 500 is sufficient during the migration process. You can increase
this value when sybmigrate rebuilds the indexes, especially if you
are migrating indexes on partitioned tables. |