Use these attributes to view detailed workload data for the DB2 capture replication server.
Capture Image Name The image name of the capture server.
Capture Server Name The job name of the capture server.
Capture Site Name The name of the capture site.
Capture Workload State The state of the workload as determined by the capture server. The following values are valid:
Changed Rows Skipped The number of changed rows that were not put on this send queue because the changes were to columns that are not part of a Q subscription or publication. The ALL_CHANGED_ROWS parameter in the IBMDB2_SUBS table was set to the default value of No.
Collection Time The date and time of the data sampling. By default, this value is displayed as MM/DD/YY hh:mm:ss, where MM is the month, DD is the day, YY is the year, hh is the hour, mm is the minute, and ss is the second.
Current Log Sequence The most recent logical log sequence number in the recovery log that the Q Capture program read for this send queue. The Q Capture program updates this column if the send queue is active.
DB2 Capture Server The DB2 subsystem or the DB2 group attach name.
Delete Row Operations Suppressed The number of delete row operations that were not put on this send queue because the Q subscription or publication was created with the option to suppress replication of delete operations.
MQ Bytes Sent The number of bytes that were put on the send queue during the collection interval, including data from the source table and the message header.
MQ Messages Sent The number of messages that were put on the send queue during the collection interval.
Origin Node The parent node of the workspace.
Queue Full Error Count The number of times that the Q Capture program retried putting messages (MQPUT) on this send queue.
Restart Log Sequence The logical log sequence number from which the Q Capture program starts putting messages on this send queue during a warm restart. This value represents the earliest log sequence number that the Q Capture program found that did not have a commit or abort record. The Q Capture program updates this column if the send queue is active.
Rows Published The number of rows (individual insert, update, or delete operations) that the Q Capture program put on this send queue.
Rows Skipped The number of rows that the Q Capture program did not transmit to this send queue because they did not meet the search condition that is defined in the Q subscription or publication.
Send Queue Name The name of the send queue.
Transactions Published The number of transactions that the Q Capture program put on this send queue.