Stable storage use is above 75 percent

Symptom

The total size of all the queues on a Replication Server has passed the set threshold. This warning message is displayed 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

You should follow these procedures when the 75% and 90% thresholds have been exceeded:

  1. Verify that the replicate database is running.

  2. If all other components are functional and the inbound queues are growing, shut down the corresponding Adaptive Server and check for an open transaction.

  3. If the outbound queues are growing, check the DSI save interval in conjunction with low block usage.