SharePlex 8.6.6 - Administration Guide

qstatus

Use the qstatus command to view statistics for the capture, post, and export queues on any system. It displays the number of messages in each queue, their age, and the current size of the queue. Typically, a message approximately corresponds to a SQL operation, but there can be multiple messages for one operation on a LONG or LOB column, and there could be just one record for numerous operations of an array insert. A message also can be an internal SharePlex operation.

When to use the qstatus command

Use the qstatus command to:

• Determine if there is data still waiting to be read by a replication process or posted to the target database.
• Estimate the speed at which SharePlex is processing by analyzing the rate at which messages accumulate.
• View the size of the queues to ensure that they do not exceed available disk space.
• Verify that all of the queues are empty when that is required for certain operational procedures or when you need to shut down replication for system maintenance, upgrades, and other administrative tasks.
• Determine if there is user activity on a target system that can cause data to go out of synchronization.

About the output

• The number of messages in a queue reflects the messages that have been read by the next SharePlex process, as well as those that have not been read. As part of its checkpoint recovery system SharePlex retains copies of messages that were sent to the next process. These messages are deleted when receipt by that process is acknowledged.
• The Backlog field indicates the number of messages yet to be read by the next SharePlex process.
• The Age field is the difference in time between when the oldest and newest messages in the queue were written to the queue.
• The presence of a Post queue on a system that also has capture and export queues indicates that this system is used both as a source system and as a target system.
• The Size field indicates the true size of a queue.

Usage

Syntax

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.