Symptom
- Replication stopped due to the error below.
W. 2022/11/04 12:16:36. WARNING #6236 SQM(xxx:x <DS>.<DB>) - /generic/sqm/sqmsp.c(1038)
WARNING: Stable queue ('xxx:x') is on hold waiting for the partition usage of the inbound queue to fall below 100 percent.
- Checking the stable device, stable device was not full
The state of some partitions includes AUTO EXTENDS flag.
Partition Logical Total Segs Used Segs State
/path/dp1 dp1 1024 1 ON-LINE///
/path/dp11 dp11 2040 2039 ON-LINE///AUTO
/path/dp12 dp12 2040 2040 ON-LINE///AUTO
/path/dp2 dp2 2040 1201 ON-LINE///
/path/dp3 dp3 2040 1906 ON-LINE///
/path/dp4 dp4 1024 1022 ON-LINE///
/path/dp5 dp5 2040 2039 ON-LINE///
/path/dp6 dp6 2040 1 ON-LINE///AUTO /path/dp7 dp7 2040 60 ON-LINE///AUTO
/path/dp9 dp9 2040 2040 ON-LINE///AUTO
/path/dp10 dp10 2040 2040 ON-LINE///AUTO
...
1> select * from rs_diskpartitions
2> go
name logical_name id num_segs status vstart
----------------------------------------------------- ----------------- -----------
/path/dp1 dp1 101 1024 1 0
/path/dp2 dp2 102 2040 1 0
/path/dp3 dp3 103 2040 1 0
/path/dp4 dp4 104 2040 1 0
/path/dp5 dp5 105 2040 1 0
/path/dp6 dp6 106 2040 17 0
/path/dp7 dp7 107 2040 17 0
/path/dp8 dp8 108 2040 17 0
/path/dp9 dp9 109 2040 17 0
/path/dp10 dp10 110 2040 17 0
/path/dp11 dp11 111 2040 17 0
…
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- AIX
Product
SAP Replication Server all versions
Keywords
CR 827530, WARNING #6236, partition full, rs_diskpartitions , 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.
SAP Knowledge Base Article - Preview