Symptom
- A large transaction was executed in the primary database and completed quickly,
- But it is not completing in the replicate database, even after an hour or longer.
- How to purge this transaction as it is blocking other transactions and the Replication Server queue is building up?
1> admin who, sqt, rdb, rdb
2> go
Spid State Info Closed Read Open Trunc Removed Full SQM Blocked First Trans Parsed SQM Reader Change Oqids Detect Orphans
---- -------------------- -------------------- ----- ------ ----------- ----------- ----------- ----------- ----------- ------ ----- ------------------- --------- ----------- ---
49 Awaiting Command 187 rds.rdb 5772 0 1 5773 0 1 0 0 st:C,cmds:463180,qid:1718069:11:0 5772 0 0 1
Read more...
Environment
SAP Replication Server (SRS)
Product
Keywords
zap, repserver , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To
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.