SAP Knowledge Base Article - Preview

2872639 - Output of sp_hep_rep_agent when RepAgent is down SAP ASE - Stand-alone


  • According to the SAP Rep Server Manuals, sp_help_rep_agent dbname, 'recovery' should show 'not running' for a repagent that is down:

  • Status: Indicates RepAgent or scanner activity. Not running: RepAgent is not running.  
    • However the procedure actually produces no output whatsoever unless the rep agent is running, making it unusable to check a rep agent status which is not running. 

    >sp_help_rep_agent rcreptest,recovery


    Replication Agent Recovery Status dbname connect_dataserver connect_database status rs_servername rs_username

    ------ ------------------ ---------------- ------ ------------- -----------

    (1 row affected)

    (return status = 0)




      • SAP Adaptive Server Enterprise (ASE)
      • Replication Agent configured


      SAP Adaptive Server Enterprise 16.0


      CR 820689, CR# 820689,  820689 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

      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.