Command Reference

10.5.3
- 10.5.5
- 10.5.4
- 10.0

Back Next

DISPLAY Command

Prints statistics on DB2 for z/OS ECCR activity to the EDMMSG data set. Also prints ECCR summary statistics to the JES job log and MVS hardcopy log.

Syntax

Use the following command syntax:

DISPLAY[,SQ][,ST][,ALL]

Or use the following shorter syntax:

DI[,SQ][,ST][,ALL]

All parameters are optional. You can specify the DISPLAY or DI command with none, one, more than one, or all of the parameters. If you specify the DISPLAY command without any parameter, by default, the command uses the LEV parameter setting from the STAT statement in the REPL2OPT DD data set. The default for the LEV parameter is ST.

To issue the ECCR DISPLAY command, use the MVS MODIFY or F command with the ECCR started task or job name.

Parameter Descriptions

SQ: Prints the SQ Display statistics report in message PWXEDM177085I and summary statistics in message PWXEDM177084I to the EDMMSG data set. Also prints the PWXEDM177084I summary statistics to the JES log and MVS hardcopy log and as a WTO message.

The SQ Display report shows counts of change records that the ECCR sent to the PowerExchange Logger for z/OS for each source table since the ECCR started, by table and record type. The counts are for low-level types of database operations that indicate logging activity, not for SQL INSERT, UPDATE, and DELETE operations. By default, the SQ statistics are printed only for tables that have a non-zero value for at least one count. To print these counts for every table from which the ECCR captures changes, including tables that have a zero or null value for all of the counts, issue the DISPLAY,SQ,ALL command.
ST: Prints the ST Display statistics report in message PWXEDM177085I and summary statistics in message PWXEDM177084I to the EDMMSG data set. Also prints the PWXEDM177084I summary statistics to the JES log and MVS hardcopy log and as a WTO message.

The ST Display report shows the total number of change records that the ECCR read from the DB2 log since the ECCR started and during the current statistics reporting interval. It also includes the average number of changes that the ECCR captured per second during the current statistics reporting interval. By default, the ST statistics are printed only for tables that have a non-zero value for the MSG_TOT field. To print these statistics for every source table, including those with a MSG_TOT value of zero or null, issue the DISPLAY,ST,ALL command.
ALL: Prints SQ or ST statistics in message PWXEDM177085I for every source table, even for tables for which all SQ counts are zero or null or for which the ST MSG_TOT field is zero or null. If you omit the ALL parameter, the ECCR prints the SQ or ST statistics only for the source tables for which the ECCR read at least one change record from the DB2 log or sent at least one record to the PowerExchange Logger. If you specify the ALL parameter without the SQ or ST parameter, the ALL parameter applies to the type of statistics that is specified by the LEV parameter of the STAT statement in the REPL2OPT statement, which is ST by default.

Example Output

ST Display report:

The following example statistics report is generated in response to the DISPLAY,ST command or to the DISPLAY command when STAT LEV=ST is used:

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 ST Display report in PWXEDM177085I shows counts of change records that the ECCR read from the DB2 log for each source table that has a non-zero numeric value in the MSG_TOT field. If you want to show these statistics for every source table, including those with a MSG_TOT value of zero or null, include the ALL parameter in the command.

The following example statistics report is generated in response to a DISPLAY,ST,ALL 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
            -             -        -  ABCNKL1.TSTP2
            -             -        -  ABCNKL1.TSTP3
            1             1        -  ABCNKL1.P707951D
            2             2        -  ABCNKL1.P707951A

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:

Report Field	Description
DB2 Log Location	In the PWXEDM177084I statistics, displays the RBA that indicates the current location of ECCR processing in the DB2 log.
DB2 Log Timestamp	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.
Current Delay	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.
Average Delay	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.
REC_TOT	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.
REC/INTV	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.
REC/PSEC	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.
MSG_TOT	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.
MSG/INTV	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.
MSG/PSEC	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.
TABLE_NAME	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

SQ Display report:

The following example statistics report is generated in response to the DISPLAY,SQ command or to the DISPLAY command when STAT LEV=SQ is specified in the REPL2OPT data set:

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 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 numeric 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 for all of these counts, issue the DISPLAY,SQ,ALL command.

Any numeric value with an integer overflow condition is displayed as asterisks, for example,

*,***,***,***

. A zero is indicated by a hyphen (-).

The following table describes the fields in the SQ Display report in PWXEDM177085I:

Report Field	Description
INSERTs	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.
UPDATEs	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.
DELETEs	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.
TABLE_NAME	Displays the name of a source table for which INSERTs, UPDATEs, and DELETEs are reported.

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

Rename Saved Search

Table of Contents

Command Reference

Command Reference

DISPLAY Command

DISPLAY Command

Syntax

Parameter Descriptions

Example Output