Symptom
- One outbound queue does not drain.
- In "admin who, sqm", First Seg.Block is not moving while Last Seg.Block is increasing:
Spid State Info Duplicates Writes Reads Bytes B Writes B Filled B Reads B Cache Save_Int:Seg First Seg.Block Last Seg.Block Next Read Readers Truncs Loss Status
---- -------------------- ------------------------------------------------------------ ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------------- ------------------------------- ------------------------------- ------------------------------- ----------- ----------- -------------------------------
16 Awaiting Message 440:0 RDS.rdb 0 705 10156464 211570 235 0 1276085 235 0:37427 37427.28 47398.16 47398.17.0 2 1 No Loss
- "admin who, sqt" shows the same Open transaction for a very long time:
1> admin who,sqt
2> go
Spid State Info Closed Read Open Trunc Removed Full SQM Blocked First Trans Parsed SQM Reader Change Oqids Detect Orphans
---- -------------------- ------------------------------------------------------------ ----------- ----------- ----------- ----------- ----------- ----------- ----------- --------------------------------------------- ----------- ----------- ------------ --------------
74 Awaiting Message 440 RDS.rdb 0 0 2 2 0 0 0 st:O,cmds:2,qid:37427:29:0 0 0 0 0
- A queue dump shows a transaction with BEGIN TRAN and UPDATE in Segment 37427 Block 29 Row 0-1, and there is no COMMIT for this transaction.
- Rebooting RepServer has no effect.
- Data is successfuly replicating to the replicate database with no errors.
Read more...
Environment
SAP Replication Server (SRS) 16.0
Product
Keywords
sysadmin, dump_queue, sqm_zap_tran , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.