Configuring Distributed Application of Transactions in DSI for HVAR

Configure distributed application of transactions during high volume adaptive replication to SAP ASE databases.

Prerequisites

Ensure you have a valid distributed transaction management (DTM) license for the replicate SAP ASE data server. See SAP ASE System Administration Guide: Volume 2 > Distributed Transaction Management > Enabling DTM features > Installing a license key.

Task

Enable support for distributed transaction management (DTM) in the SAP ASE replicate database.
See Distributed Transaction Management in the SAP ASE System Administration Guide: Volume 2.
1. Enable DTM
  At the replicate SAP ASE data server, enter:
```
sp_configure 'enable dtm', 1
```
2. Restart the SAP ASE data server.
3. Grant the distributed transaction role to the SAP Replication Server maintenance user.
```
sp_role "grant", dtm_tm_role, maintenance user
```
Enable HVAR for the connection to the replicate SAP ASE database.
For example, to enable HVAR for a single connection, enter:
```
alter connection to data_server.database
set dsi_compile_enable to ‘on’
go
```
You can also enable and configure HVAR at the server or table levels. See Enable HVAR.
(Optional) Provide more worker threads to improve performance for distributed application of transactions.
1. Specify the number of worker threads.
  Enter:
```
configure replication server
set worker_thread_num to ‘number_of_worker_threads’
go
```
  where number_of_worker_threads specifies the number of worker threads.
2. Restart SAP Replication Server.
Enable distributed application of transactions in SAP Replication Server.
1. Set the dt_apply parameter to a value bigger than one to enable distributed application of transactions for specific connections to the replicate database or at the server-level for all connections
  
  dt_apply controls the maximum number of tasks that SAP Replication Server uses to apply one transaction. The default for dt_apply is 1 where there is no distributed application of transactions. The maximum you can set is 8 and the minimum is 1.
  
  Use double quotation marks around the value for number_of_distributed_application_tasks.
  For example, to enable distributed application of transactions:
  - For a single connection to the replicate database, enter:
```
alter connection to data_server.database
set dt_apply to "number_of_distributed_application_tasks"
go
```
  - At the server level for all connections, enter:
```
configure replication server
set dt_apply to "number_of_distributed_application_tasks"
go
```
2. Restart the connection to the database if you configured dt_apply at the connection level.
  Restart SAP Replication Server for a server-level change.