If the inbound queue requires more disk space, a message similar to the following is displayed in the Replication Server error log:
_SQM_ADD_SEGMENT: Going to wait for a segment to be freed. Administrative action is needed.
To determine which stable queues hold the segments, log in to the RSSD and execute the following query:
select q_number, q_type, count(*) from rs_segments group by q_number, q_type
The output of this query shows the number of segments each stable queue is using. Each segment is 1MB of disk space. Look at the queues with the largest number of segments:
A q_type of 0 means an outbound queue. If any of the outbound queues have more than two segments, verify that the connections they service are operating. See Chapter 8, “Data Server Interface Problems” and Chapter 6, “Replication Server Interface Problems” for more details.
A q_type of 1 is an inbound queue. If one of these queues has a large number of segments, it may contain an orphaned transaction. See “Orphaned transactions” for more information.