Stable Storage Use is Above 75 Percent

The total size of all the queues on a Replication Server has passed the set threshold.

Symptom

This message appears in the Replication Server error log:

W. 2006/06/13 18:41:12. WARNING #6089 SQM(129:0
TTTdss.eanp) - qm/sqmsp.c(1317) WARNING: Stable Storage
Use is Above 75 percent

Explanation

A Replication Server has two default thresholds (75% and 90%) for stable devices. A warning message is issued each time these thresholds are exceeded.

Solution

When the 75% and 90% thresholds have been exceeded:

Verify that the replicate database is running.
If all other components are functional and the inbound queues are growing, shut down the corresponding Adaptive Server and check for an open transaction.
If the outbound queues are growing, check the DSI save interval with low block usage.