2554012 - FAQ: SAP HANA Big Endian to Little Endian Migration for IBM Power

Parameter

Description

Limited by

Recommendation

File

framework.threadPoolSize

Number of worker threads. Increase the number of worker threads to avoid queuing due to insufficient threads, the default values could be much lower.

CPU on dpagent machine

# logical cores of dpagent machine * 3

dpagentconfig.ini on dpagent installation

framework.fetchSize

The minimum number of rows the dp agent fetches from the adapter in one step.

RAM on dpagent machine

10000

dpagentconfig.ini on dpagent installation

adapterSession.keepAliveTimeInHours

Timeout of the adapter session.

-

At least 24, suggested to match expected migration time

dpagentconfig.ini on dpagent installation

-Xmx

Java heap space used by dpagent Java process.

RAM on dpagent machine

Memory of dpagent machine, should be at least 32GB

dpagent.ini on dpagent installation

concurrency

Number of actions to perform in parallel by the migration tool.

CPU on source and target system

# of logical cores available

migration.properties

ddlconcurrency

Number of parallel DDL operations. Limited by concurrency parameter.

CPU on source and target system

concurrency/8

migration.properties

dataconcurrency

Number of data streams processed in parallel.

CPU on source and target system

concurrency - 1

migration.properties

splitThreshold

The number of rows that are processed at once by the migration tool. Tables and physical partitions that contain less rows are processed at once, tables and physical partitions that contain more rows are processed in units of work of splitThreshold rows.

RAM of source and target system

Optimize as high as possible for the largest table

migration.properties

parallelTaskOperations

Number of units of work to be handled in one data provisioning task.

RAM/CPU of target system

concurrency/8

migration.properties

parallelPartitionsInTask

Number of physical partitions to put together in one task.

RAM/CPU of source and target system

Default setting of 12 should be sufficient

migration.properties