CDC Guide for i5/OS

10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Performance Details in Workflow Monitor

In Workflow Monitor, you can view performance details in the run properties for a CDC session to assess the efficiency of the CDC session and extraction processing.

If session performance is degraded, you can use data in the Performance Counter column to determine the bottleneck.

PWXPC does not store performance details in the repository so you cannot view performance details for previous executions of a CDC session.

To enable the collection of performance details, select

Collect performance data

on the

Properties

tab of the CDC session properties.

When the CDC session runs, PWXPC refreshes performance statistics every 10 seconds.

If you enable a resume recovery strategy for the CDC session, PWXPC displays data for all Performance Counter fields.

The following table describes the Performance Counter fields:

Performance Counter Field	Description
1 PowerExchange CDC Reader Status:	Current status of the PWXPC reader, as indicated by one of the following values: No Data To Process . In the last read, PowerExchange did not pass data to PWXPC. Restart Advance . PowerExchange passed restart tokens to PWXPC but did not pass change data. Processing Data . PowerExchange passed change data and restart tokens to PWXPC for processing.
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: If PowerExchange is reading large amounts of change data from the change stream, this value is usually large and reflects the maximum PowerExchange throughput. If PowerExchange is waiting for change data at the end of the change stream, this value is small. The following factors can increase this value: Large network bandwidth CDC offload processing Multithreaded processing
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: Idle . Waiting for change data. Processing Data . Data is being processed. Recovery Disabled . If a resume recovery strategy is not enabled, the PWXPC CDC reader cannot get PowerCenter status information.
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: Number of available DTM buffers Responsiveness of the target Number of transformations in the pipeline
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.

Rename Saved Search

Table of Contents

CDC Guide for i5/OS

CDC Guide for i5/OS

Performance Details in Workflow Monitor

Performance Details in Workflow Monitor