SAP Knowledge Base Article - Preview

2479547 - BCP or insert select results in single large transaction for MSA replicated table - Repserver


  • BCP in data into permanent temp table in a user defined tempdb.
  • Copy the data into a database table that is MSA replicated.
  • The primary db settings are:
    • sp_reptostandby 'bars', 'all'
    • sp_setrepdbmode bars ,'UDIS','on'
    • sp_setrepdbmode 'bars', 'threshold', '1'
    • sp_config_rep_agent bars,'send warm standby xacts','true



  • SAP Replication Server (SRS) 15.7.1
  • SAP Replication Server Real Time Loading (RTL) 15.7.1
  • SAP Replication Server Heterogeneous Edition 15.7.1


SAP Replication Server 15.7 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, real-time loading edition


repserver locks , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.