Symptom
- Outbound DSI queue is not moving.
- Outbound DSI queue appears stuck.
- The "First Trans" column in the "admin who,sqt" output shows status 'C' or 'R', and high "cmd" count:
Spid State Info ... First Trans ...
---- ------- ----------------- ------------------------------
130 Active 103 dsname.dbname ... st:C,cmds:nnnnnnn,qid:988:57:0 ...
- The number "nnnnnnn" is larger than the number reported by "sp_configure locks" executed in the target dataserver ("dsname").
Read more...
Environment
- SAP Replication Server
- SAP Replication Server Real Time Loading
- SAP Replication Server Heterogeneous Edition
- Sybase Replication Server
- Sybase Replication Server Real Time Loading
- Sybase Replication Server Heterogeneous Edition
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, real-time loading edition all versions ; Sybase Replication Server software all versions ; Sybase Replication Server, heterogeneous edition all versions ; Sybase Replication Server, real-time loading edition all versions
Keywords
Repserver hung hangs frozen sp_configure 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.