PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5
- All Products
Performance Counter Field
| Description
|
---|---|
1 PowerExchange CDC Reader Status:
| Current status of the PWXPC reader, as indicated by one of the following values:
|
1.1 Time Last Data Row Read
| Time, in milliseconds, that PWXPC took to read the data last received from PowerExchange.
|
1.2 Data Rows In Current Interval
| Number of change records received from PowerExchange during the current statistics interval.
|
1.3 End Packets In Current Interval
| Number of UOWs received from PowerExchange during the current statistics interval.
|
1.4 Data Read Rate In Current Interval (rows/sec)
| Number of change records read per second by PowerExchange during the current statistics interval.
The value varies, based on the quantity of change data:
The following factors can increase this value:
|
1.5 Mean Data Read Rate (rows/sec)
| Mean number of change records that PowerExchange read per second, from the start of the CDC session.
|
1.6 Max Data Read Rate (rows/sec)
| Maximum number of change records that PowerExchange read per second during a statistics interval, from the start of the CDC session.
|
2 PowerCenter Processing Status:
| Overall status of the CDC session, as indicated by one of the following values:
|
2.1 Time Of Last Commit
| Time stamp of the last commit to a target.
|
2.2 Rows Processed To Commit In Current Interval
| Number of change records that the PWXPC reader flushed during the current statistics interval. This count includes the change records in all committed UOWs. Some of these UOWs might have started before the current statistics interval began.
|
2.3 Commit Rate In Current Interval (rows/sec)
| Processing rate, in number of change records per second, for the change records for the UOW that was last committed during the current statistics interval. This processing includes reading the UOW from PowerExchange and committing the change data to the targets.
The following factors can affect this rate:
|
2.4 Mean Commit Rate (rows/sec)
| Mean number of change records per second for the rate displayed in
2.3 Commit Rate In The Current Interval .
This value differs from the
2.6 Mean Throughput Rate value in that it takes into account only the time when the session is actively processing data. This value does not reflect processing overlap in PowerCenter.
|
2.5 Max Commit Rate (rows/sec)
| Maximum number of change records per second for the commit rate displayed in
2.3 Commit Rate In The Current Interval , from the start of the CDC session.
|
2.6 Mean Throughput (rows/sec)
| Mean rate of processing for the CDC session.
|
2.7 Max Throughput (rows/sec)
| Maximum throughput for the CDC session.
|
2.8 Commits In Current Interval
| Number of commits processed to completion by the target during the current statistics interval.
|
2.9 Commits Pending
| Number of commits that the PWXPC reader issued but that have not yet reached the targets. A large value might indicate problems with target responsiveness.
|
3 Capture Timestamps
| -
|
3.1 Timestamp On Last End Packet Read
| The capture timestamp, DTL__CAPXTIMESTAMP, from the last UOW read for a source in the CDC session.
|
3.2 Timestamp On Last Target Commit
| The capture timestamp, DTL__CAPXTIMESTAMP, from the last UOW committed to the target.
|
4 Totals
| -
|
4.1 Elapsed Time
| Total elapsed time for the CDC session.
|
4.2 Rows Read
| Total number of change records read from PowerExchange.
|
4.3 End Packets Read
| Total number of UOWs read.
|
4.4 Time in PowerExchange Processing
| Total time of PowerExchange processing for the CDC session.
|
4.5 Rows Processed
| Total number of change records processed through PowerCenter and committed to the targets.
|
4.6 Commits to Target
| Total number of flushes that the PWXPC reader issued and that were committed to the targets.
|
4.7 TS on Last Commit minus TS at Commit (2.1-3.2)
| Result from subtracting
3.2 Timestamp On Last Target Commit value from the
2.1 Time Of Last Commit value. If this result is negative, the value is enclosed in parentheses.
|