The reports are printed to the EDMMSG data set at the reporting interval that is set in the STAT statement of the REPL2OPT DD data set and in response to an ECCR DISPLAY command. The type of statistics depends on the LEV parameter in the STAT statement or on the parameters that you specify in the DISPLAY command. The default for the LEV parameter is ST. For more information about the DISPLAY command, see the
PowerExchange Command Reference
.
The following example statistics report is generated when STAT LEV=ST is set in the REPL2OPT data set or in response to the DISPLAY,ST command:
PWXEDM177084I ABCDSNB capture statistics at 2017-06-16 19.24.22
DB2 Log Location 00000000000A9B69565A.0000.0000
DB2 Log Timestamp 2017-06-16 19.22.47
Current Delay= 1.59 sec Average Delay= 1.60 sec
REC_TOT RECS/INTV RECS/SEC
DB2 log records 209 209 -
EDM records 8 8 -
PWXEDM177085I ST Display
MSG_TOT MSG/INTV MSG/PSEC TABLE_NAME
5 5 - ABCNKL1.TSTP1
1 1 - ABCNKL1.P707951D
2 2 - ABCNKL1.P707951A
The entire report is written to the EDMMSG data set. The summary statistics in message PWXEDM177084I are also written to the JES job log and MVS hardcopy log and as a WTO message.
The ST Display report in message PWXEDM177085I shows counts of change records that the ECCR read from the DB2 log for each source table that has a non-zero value in the MSG_TOT field. To show these statistics for every source table, including those with a MSG_TOT value of zero or null, use the DISPLAY,ST,ALL command.
Any numeric value with an integer overflow condition is displayed as asterisks, for example,
*,***,***,***
. A zero or null value is indicated by a hyphen (-).
The following table describes the fields in the PWXEDM177084I summary statistics and PWXEDM177085I ST Display statistics:
|
In the PWXEDM177084I statistics, displays the RBA that indicates the current location of ECCR processing in the DB2 log.
|
|
In the PWXEDM177084I statistics, displays the timestamp of the last DB2 log record that the ECCR read. This timestamp reflects the date and time that the record was written to the DB2 log.
|
|
In the PWXEDM177084I statistics, displays the delay, in seconds, for the last change record. The delay is the difference between the time when a change record was written to the DB2 log and the time when the ECCR read the record.
|
|
In the PWXEDM177084I statistics, displays the average delay, in seconds, for processing a change record during the statistical reporting period. The delay is the difference between the time when a change record was written to the DB2 log and the time when the ECCR read the record.
|
|
In the PWXEDM177084I statistics, displays the total number of DB2 log records and the total number of EDM records that the ECCR read since the ECCR started.
|
|
In the PWXEDM177084I statistics, displays the number of DB2 log records and the number of EDM records that the ECCR read since the last statistics reporting interval. The reporting interval is specified in the SEC parameter in the STAT statement in the REPL2OPT data set.
|
|
In the PWXEDM177084I statistics, displays the average number of DB2 log records and the average number of EDM records that the ECCR read per second during the current statistics reporting interval.
|
|
In the PWXEDM177085I ST Display report, displays the total number of changes that the DB2 ECCR captured for each table since the ECCR started. This count includes backout records.
|
|
In the PWXEDM177085I ST Display report, displays the total number of changes that the DB2 ECCR captured for each table since the last statistics reporting interval. This count includes backout records.
|
|
In the PWXEDM177085I ST Display report, displays the average number of changes that the ECCR captured per second for each table during the current statistics reporting interval. This average includes backout records.
|
|
In the PWXEDM177085I ST Display report, displays the name of a source table for which the MSG_TOT, MSG/INTV, and MSG/PSEC statistics are reported.
|
If no ST type of activity has occurred, the following message is issued in response to the DISPLAY,ST command instead of the PWXEDM177085I message:
PWXEDM177086I No ST activity
The following example statistics report is generated when STAT LEV=SQ is set in the REPL2OPT data set or in response to the DISPLAY,SQ command:
PWXEDM177084I ABCDSNB capture statistics at 2017-06-16 19.24.22
DB2 Log Location 00000000000A9B69565A.0000.0000
DB2 Log Timestamp 2017-06-16 19.22.47
Current Delay= 1.59 sec Average Delay= 1.60 sec
REC_TOT RECS/INTV RECS/SEC
DB2 log records 209 209 -
EDM records 8 8 -
PWXEDM177085I SQ Display
INSERTs UPDATEs DELETEs TABLE_NAME
3 - 2 ABCNKL1.TSTP1
1 - - ABCNKL1.P707951D
1 1 - ABCNKL1.P707951A
The entire report is written to the EDMMSG data set. The summary statistics in PWXEDM177084I are also written to the JES job log and MVS hardcopy log and as a WTO message.
The SQ Display report in PWXEDM177085I shows counts of records that the ECCR sent to the PowerExchange Logger for z/OS since the ECCR started, by table and record type. These counts are for low-level types of database operations that indicate logging activity, not for SQL INSERT, UPDATE, and DELETE operations.
Only tables that have a non-zero value for at least one count are displayed. To display these counts for every table from which the ECCR captures changes, including tables that have a zero value for all of these counts, use the DISPLAY,SQ,ALL command.
Any numeric value with an integer overflow condition is displayed as asterisks, for example,
*,***,***,***
. A zero or null value is indicated by a hyphen (-).
If no SQ type of activity has occurred, the following message is issued in response to the DISPLAY,SQ command instead of the PWXEDM177085I message:
PWXEDM177086I No SQ activity
The following table describes the fields in the SQ Display report in PWXEDM177085I:
|
Displays the number of records of type "insert" that the ECCR sent to the PowerExchange Logger for z/OS for a source table since the ECCR started. The count is for low-level database operations of type of "insert," not for SQL insert operations.
|
|
Displays the number of records of type "update" that the ECCR sent to the PowerExchange Logger for z/OS for a source table since the ECCR started. The count is for low-level database operations of type of "update," not for SQL update operations.
|
|
Displays the number of records of type "delete" that the ECCR sent to the PowerExchange Logger for z/OS for a source table since the ECCR started. The count is for low-level database operations of type "delete," not for SQL delete operations.
|
|
Displays the name of a source table for which INSERTs, UPDATEs, and DELETEs are reported.
|
