What does the 'admin stats,backlog' command report?

[Former Member]

The documentations says the 'admin stats,backlog' command reports:

"Reports the volume of replicated transactions awaiting distribution in the inbound and outbound queues in terms of segments and blocks."

It's really giving the same output as:

> admin stats, SQM, SQMRBacklogSeg, MY_ASE_SERVER, MyDatabase;

> admin stats, SQM, SQMRBacklogBlock, MY_ASE_SERVER, MyDatabase;

(but for all ASE servers and databases)

Through experimentation, I've figured out that this does not include data waiting in an outbound DSI for subscription replication (going to a replicate ASE server, for example).   Ie., "distribution" is used in a narrow repserver sense, not in a general "replicate data to ASE servers"  sense.

If so, the option should be named something like "distributor_backlog", not "backlog"

Ben Slade

[Former Member]

Replying to my own post:

I do notice that admin stats, backlog is reporting queue up data sometimes.   Maybe it only reports backlogs when the DSI is suspended?  Ie., if a destination ASE server is slow, DSI queueing isn't included in admin stats, backlog???   I will research this.