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 ONE Support launchpad (Login required).

Search for additional results

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