SAP Knowledge Base Article - Preview

2191603 - How to purge a transaction from a queue - SRS

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

SAP Replication Server all versions

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.