Use these attributes to view detailed workload data for the DB2 apply replication server.
Agents The number of Q Apply agents.
Apply Image Name The image name of the apply server.
Apply Server Name The job name of the apply server.
Apply Site Name The name of the apply site.
Apply Sleep Time The number of milliseconds that Q Apply agents for this receive queue were idle while waiting for work.
Apply Workload State The state of the workload as determined by the apply server. The following values are valid:
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 Memory The amount of memory in bytes that the Q Apply browser thread used for reading transactions from this queue.
DB2 Apply Server The DB2 subsystem or the DB2 group attach name.
Deadlock Retries The number of times that the Q Apply program reapplied row changes because of lock timeouts and deadlocks.
Heartbeat Latency The average elapsed milliseconds between the time that heartbeat messages were sent by the Q Capture program and the time that they were received by the Q Apply program.
Job Dependencies The number of transactions that are delayed because of job name dependencies.
Key Dependencies The total number of replication key constraints that were detected, forcing transactions to be serialized.
Memory Full Time The number of seconds that the Q Apply program was unable to build transactions from this receive queue because its agents were using all the available memory to apply transactions.
Monster Transactions The number of transactions that exceeded the memory limit for the receive queue that was set in the IBMDB2_RECVQUEUES table.
MQ Bytes Read The number of bytes that were read from this receive queue.
OKSQLSTATE Errors The number of row changes that caused an SQL error that is defined as acceptable in the OKSQLSTATES field of the IBMQREP_TARGETS table. The Q Apply program ignores these errors.
Oldest Commit LSN The commit log sequence number (LSN) from the source recovery log that corresponds to the oldest transaction that was applied.
Oldest Commit Sequence An internal log marker that corresponds to the oldest transaction that was applied.
Oldest In-flight Transactions A time stamp that represents the source commit time of the oldest currently in-flight transaction. An in-flight transaction has not been fully applied and committed at the target.
Origin Node The parent node of the workspace.
Queue Depth The number of messages on the queue.
Queue Percent Full The fullness of the queue as a percentage.
Queue Start Time The time stamp at the Q Apply server when the receive queue was started.
Receive Queue Name The name of the receive queue.
RI Dependencies The total number of referential integrity (RI) conflicts that were detected, forcing transactions to be serialized.
RI Retries The number of times that the Q Apply program had to reapply row changes because of referential integrity (RI) conflicts when the transactions that they were part of were executed in parallel.
Rows Applied The number of insert, update, and delete operations from this receive queue that the Q Apply program applied to the target.
Rows Not Applied The number of rows that were unable to be applied and were entered in the IBMDB2_EXCEPTIONS table.
Rows Processed The number of rows that were applied but might not yet be committed to the target.
Rows Read The number of rows that were read from this receive queue.
Spilled Rows The number of rows that the Q Apply program sent to temporary spill queues while targets were being loaded or while Q subscriptions were placed into a spill state by the spillsub parameter of the MODIFY or asnqacmd command.
Spilled Rows Applied The number of spilled rows that were applied to the target.
Transactions Applied The number of transactions from this receive queue that the Q Apply program committed to the target.
Transactions Read The number of transactions that were read from this receive queue.
Transactions Serialized The number of transactions that conflicted with another transaction, because of either a row conflict or a referential integrity conflict. In these cases, the Q Apply program suspends parallel processing and applies the row changes within the transaction in the order that they were committed at the source.
Unique Dependencies The total number of unique index constraints that were detected, forcing transactions to be serialized.
Unique Retries The number of times that the Q Apply program tried to reapply rows that were not applied in parallel because of unique index constraints.