Example Output
The following summary statistics are written in response to a DISPLAY command to the EDMMSG data set:
PWXEDM177084I KHADB201 capture statistics at 2013-10-23 16.39.13 031
DB2 Log Location 00000000000060D9DD3B.0000.0000
DB2 Log Timestamp 2013-10-23 16.30.01
Current Delay= sec Average Delay= sec
DB2 Log records REC_TOT REC_INTV REC_PSEC
5,475 0 0
EDM Messages MSG_TOT MSG_INTV MSG_PSEC
2 0 0
These summary statistics are also written to the JES log and MVS hardcopy log in response to a DISPLAY, SQ or DISPLAY,ST command.
The following summary and detail-level statistics report is written to the EDMMSG data set in response to a DISPLAY,ST command:
PWXEDM177084I KHADB201 capture statistics at 2013-10-24 16.24.30
DB2 Log Location 00000000000061148000.0000.0000
DB2 Log Timestamp 2013-10-24 16.10.52
Current Delay= sec Average Delay= sec
DB2 Log records REC_TOT REC_INTV REC_PSEC
7,136 5 0
EDM Messages MSG_TOT MSG_INTV MSG_PSEC
2 0 0
PWXEDM177085I DETAIL LEVEL STATISTICS FOLLOW BELOW
MSG_TOT MSG_INTV MSG_PSEC TABLE_NAME
2 0 0 KHALL1.TENCHAR
0 0 0 SYSIBM.SYSTABLESPACE
0 0 0 SYSIBM.SYSTABLES
0 0 0 SYSIBM.SYSCOLUMNS
0 0 0 SYSIBM.SYSFIELDS
0 0 0 SYSIBM.SYSCOPY
In this report, the detail-level statistics in message PWXEDM177085I show totals of changes captured for each table across different time periods.
The following summary and detail-level statistics report is written to the EDMMSG data set in response to a DISPLAY,SQ command:
PWXEDM177084I KHADB201 capture statistics at 2013-10-24 16.24.42
DB2 Log Location 00000000000061148000.0000.0000
DB2 Log Timestamp 2013-10-24 16.10.52
Current Delay= sec Average Delay= sec
DB2 Log records REC_TOT REC_INTV REC_PSEC
7,136 0 0
EDM Messages MSG_TOT MSG_INTV MSG_PSEC
2 0 0
PWXEDM177085I DETAIL LEVEL STATISTICS FOLLOW BELOW
TABLE: KHALL1.TENCHAR
2 INSERTS, 0 UPDATES, 0 DELETES
In this report, the detail-level statistics in message PWXEDM177085I show counts of inserts, updates, and deletes captured since the ECCR started for each table.
The following table describes all of the fields in the summary and detail-level reports:
|
Displays the RBA of the current location of ECCR processing in the DB2 log.
|
|
Displays the time stamp of the last DB2 log record that the ECCR read. This time stamp reflects the date and time that the record was written to the DB2 log.
|
|
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.
|
|
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 DB2 Log records section of the summary report, displays the total number of DB2 log records that were read by the ECCR since the ECCR started.
|
|
In the DB2 Log records section of the summary report, displays the number of DB2 log records that were read by the ECCR since the last statistics reporting interval.
|
|
In the DB2 Log records section of the summary report, displays the average number of DB2 log records that the ECCR read per second during the current statistics reporting interval.
|
|
In the EDM Messages section of the summary report, displays the total number of changes that the DB2 ECCR captured since the ECCR started. This count includes backout records.
The PWXEDM177084I message shows a grand total across all tables, whereas the PWXEDM177085I message from a DISPLAY,ST command shows the total for each table.
|
|
In the EDM Messages section of the summary report, displays the total number of changes that the DB2 ECCR captured since the last statistics reporting interval. This count includes backout records.
The PWXEDM177084I message shows a grand total across all tables, whereas the PWXEDM177085I message from a DISPLAY,ST command shows the total for each table.
|
|
In the EDM Messages section of the summary report, displays the average number of changes that the ECCR captured per second during the current statistics reporting interval. This average includes backout records.
The PWXEDM177084I message shows the average across all tables, whereas the PWXEDM177085I message from a DISPLAY,ST command shows the average for each table.
|
|
In the EDM Messages section of the summary report, displays the name of the table for which the MSG_TOT, MSG_INTV, and MSG_PSEC statistics are reported.
|
|
In the detailed SQL operation statistics report, displays the name of the table for which the INSERTS, UPDATES, and DELETES statistics are reported.
|
|
In the detailed SQL operation statistics report, displays the total number of inserts on the table since the ECCR started.
|
|
In the detailed SQL operation statistics report, displays the total number of updates on the table since the ECCR started.
|
|
In the detailed SQL operation statistics report, displays the total number of deletes on the table since the ECCR started.
|
