on 2021 Mar 02 8:09 AM
Hi,
We have setup a Mobilink replication between an SAP SQL Anywhere as a remote database and an SAP IQ server as a consolidate database.
Upon initial synchronization, we noticed that the insert into SAP IQ was happening in a batch size of 10 rows. We understood that this was due to default batch size Mobilink uses. So, we tried to optimize the inserts into IQ by increasing the batch size by adding the -s option to the mlsrv17/mobilink server command. After adding this option, we noticed that the inserts into some tables were happening at a larger batch size but for some tables it was inserting one row at a time/batch size of 1 row. We couldn't figure out why Mobilink server was behaving this way for different tables.
We tried using transactional uploads by adding the -tu option to the mobilink client dbmlsync and added option -tx for the Mobilink server. We saw no difference with this approach and Mobilink server was still doing inserts into some large tables in one row batches.
We don't see any option to do bulk insert data into SAP IQ via Mobilink. Any changes we do with batch sizes on both the Mobilink client or Mobilink server did not yield any noticeable performance gain.
Environment details below:
Remote Database: Operating System: CentOS 8.2.2004 Database: SAP SQL Anywhere 17.0.10.6155 Platform: Azure cloud RAM: 64 GB CPU: 16
Consolidate Database: Operating System: CentOS 8.3.2011 Database: SAP IQ 16.1 SP04.08 Platform: Azure cloud RAM: 256 GB CPU: 8
Please let us know if there is a way to make Mobilink use bulk insert/load commands into SAP IQ consolidate database instead of batch inserts.
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.