Configuration Considerations for SAP ASE

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:

ParameterDescription
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:

ParameterDescription
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.