Use these attributes to view detailed server 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 Server Status The status of the NetView connection to the capture server. The following values are valid:
Capture Site Name The name of the capture site.
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.
Current Log Time The time stamp at the Q Capture server of the latest database commit that was seen by the Q Capture log reader.
DB2 Capture Server The DB2 subsystem or the DB2 group attach name.
End of Log Time The time stamp at the Q Capture control server when the Q Capture program reached the end of the log.
End of Logs The number of times that the Q Capture program reached the end of the log.
Log Read API Time The number of milliseconds that the Q Capture program spent using the DB2 log read application program interface (API) to retrieve log records.
Log Read Calls The number of log read API calls that the Q Capture program made.
Log Reader Sleep Time The number of seconds that the Q Capture log reader thread slept because there were no changes to capture or because the Q Capture program is operating at its memory limit.
Maximum Transaction Size The largest transaction, in bytes, that the Q Capture program processed.
Origin Node The parent node of the workspace.
Restart Log Sequence The logical log sequence number in the recovery log at which the Q Capture program starts during a warm restart. This value represents the earliest log sequence number that the Q Capture program found for which a commit or abort record has not yet been found.
Rows Processed The number of rows (individual insert, update, or delete operations) that the Q Capture program read from the log.
Transaction Memory Used The memory that the Q Capture program used to construct transactions from the log.
Transactions Processed The number of transactions that the Q Capture program processed.
Transactions Skipped The number of transactions (containing changed rows) that were not put on queues because the changes were to columns that are not part of a Q subscription or publication, for example, the ALL_CHANGED_ROWS parameter in the IBMDB2_SUBS table was set to No.
Transactions Spilled The number of transactions that the Q Capture program spilled to a file after exceeding the MEMORY_LIMIT threshold.