Show TOC

HANA SP10 Transaction ID Performance ImprovementLocate this document in the navigation structure

HANA SP10 provides a new way to access the current update transaction ID which is much quicker than previous versions. Replication Agent for SAP HANA automatically uses this new SAP HANA functionality to improve the performance of the transactional replication mode and transactional change data capture (CDC) replication mode.

One effect is that Replication Agent for SAP HANA stores the transaction ID as a bigint, instead of an integer.

These tables are affected on the primary database:

  • trigger queue

  • shadow tables

These tables are affected on the replicate database:

  • staging tables

  • transaction log table

In order to take advantage of this new functionality, undeploy and redeploy the existing models to migrate to the new version of Replication Agent for SAP HANA.