Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Commands
  3. Adabas Log-Based ECCR Commands
  4. Batch VSAM ECCR Commands
  5. CICS/VSAM ECCR Commands
  6. Datacom Table-Based ECCR Commands
  7. DB2 for z/OS ECCR Commands
  8. IDMS Log-Based ECCR Commands
  9. IMS Synchronous ECCR Commands
  10. IMS Log-Based ECCR Commands
  11. PowerExchange Agent Commands
  12. PowerExchange Condense Commands
  13. PowerExchange Listener Commands
  14. PowerExchange Logger for MVS Commands
  15. PowerExchange Logger for Linux, UNIX, and Windows Commands
  16. pwxcmd Commands

Command Reference

Command Reference

Back Next

STATISTICS Command

STATISTICS Command

Prints statistics messages about the changes that the Datacom table-based ECCR captured. The messages are printed to the DTLLOG and DTLOUT data sets.
Depending on the command parameter you specify, this command can print capture statistics since the start of the ECCR, at the end of a specific interval, since the last execution of the STATISTICS command, or when the ECCR reaches the end of the change stream in the Datacom CDC tables. The ECCR always prints capture statistics at the end of its run.
For the ECCR to report statistics for each change stream read, you must set the CAPT_STATS parameter to Y the RUNLIB(ECCRDCMP) member or specify the STATISTICS ON command after the ECCR starts.

Syntax

Use the following command syntax to print message PWX-06182, which reports totals for changes captured since the start of the ECCR run: 
F 
eccr_task_name
,STATISTICS
Use the following command syntax to specify the interval for which to print message PWX-06181, which reports totals for changes captured during the interval: 
F 
eccr_task_name
,STATISTICS 
minutes
Use the following command syntax to print PWX-06153 statistics messages by registered source for the period since the last execution of the STATISTICS command: 
F 
eccr_task_name
,STATISTICS SINCE [TERSE]
Use the following command syntax to control whether statistics are printed each time the ECCR reaches the end of the change stream in the Datacom CDC tables: 
F 
eccr_task_name
,STATISTICS {OFF|ON}
In all of these commands, the
eccr_task_name
 is required. This variable represents the name of the Datacom table-based ECCR started task or batch job.
Do not specify multiple parameters on the same command, for example,
minutes
 and SINCE.

Parameter Descriptions

The following parameters are optional on the STATISTICS command:
minutes
Defines the interval, in minutes, for which the ECCR collects statistics and prints a PWX-06181 message. This message reports the number of inserts, deletes, updates, and commits that were captured during the interval. Use this positional parameter to print statistics at a specific frequency, for example, every 60 minutes. This number of minutes overrides the CAPT_STATS_INTVL parameter value for the duration of the ECCR run. Valid values are 1 through 1440. No default is provided.
OFF
Does not print PWX-06153 messages when the ECCR reaches the end of the change stream in the Datacom CDC tables. However, PWX-06153 messages are still be printed at the end of the ECCR run and can be printed for a subsequent STATISTICS
minutes
 or STATISTICS SINCE command. The STATISTICS OFF command is analogous to the CAPT_STATS=N parameter in the ECCR configuration member. When the command is issued, the ECCR prints message PWX- 07804 to indicate that statistics reporting is turned off.
ON
Prints PWX-06153 messages at the end of the ECCR run and at the end of the change stream. The PWX-06153 messages report the number of inserts, deletes, and updates that were processed for each registered source, grouped by change stream read. The STATISTICS ON command is analogous the CAPT_STATS=Y parameter in the ECCR configuration member. When this parameter is used, the ECCR prints message PWX-07803 to indicate that statistics reporting is turned on.
SINCE
Prints PWX-06153 messages for the period since the last execution of the STATISTICS command. The PWX-06153 messages report the number of inserts, deletes, updates, and commits that were processed for each registered source during this period. Messages PWX-06183 and PWX-06184 identify the boundaries of this block of messages. Message PWX-06184 provides totals for all sources for the period. If you schedule the command with this parameter, you can print statistics with regular periodicity, such as daily or weekly.
SINCE TERSE
Prints PWX-06153 messages only for registered sources for which the ECCR captured changes since the last execution of the STATISTICS command. The PWX-06183 message includes counts only for the registered sources for which inserts, updates, or deletes were committed.

Example Output

The following statistics messages are printed as a result of the STATISTICS command when the ECCR parameter CAPT_STATS_INTVL=10 is specified: 
PWX-07702 DCOM TB CDC, ECCR, Thu May 17 14:02:45.934 2012, Registration read started.
PWX-06118 Registration loaded: DBName: MUF12345 RegName: td7crcol.1 Creator: ab_coll Table: AB_COLL_COL
PWX-07745 DCOM TB CDC, ECCR, Thu May 17 14:02:46.881 2012, Registration active...,DB:MUF12345,Name:td7crcol.1,Creator:ab_coll,Table:AB_COLL_COL.
PWX-06118 Registration loaded: DBName: MUF12345 RegName: td7crcrs.1 Creator: ab_crse Table: AB_CRSE_CRS
PWX-07745 DCOM TB CDC, ECCR, Thu May 17 14:02:46.886 2012, Registration active...,DB:MUF12345,Name:td7crcrs.1,Creator:ab_crse,Table:AB_CRSE_CRS.
PWX-07703 DCOM TB CDC, ECCR, Thu May 17 14:02:46.978 2012, Registration read completed.
PWX-07805 Statistics interval subtask started, collection interval 10 minute(s)
PWX-07701 DCOM TB CDC, ECCR, Thu May 17 14:03:22.578 2012, Initialisation completed.
PWX-06181 Interval 12/05/17 14:13:22 I=000000000003 D=000000000001 U=000000000004 C=000000000007 Log=00/01/01 00:00:00.00
PWX-06181 Interval 12/05/17 14:23:22 I=000000000005 D=000000000000 U=000000000004 C=000000000008 Log=00/01/01 00:00:00.00
PWX-07812 Latest time processed 00/01/01 00:00:00.000000 Records processed 40 (Datacom capture)
PWX-07813 Datacom RTTB CDC, Reader Task Latest---------->
                    captured data 00/01/01 00:00:00.000000.
PWX-07814 Datacom RTTB CDC, Reader Task Latest---------->
                    records processed 0000000040.
PWX-06153 td7crcol.1        I=000000000008 D=000000000001 U=000000000004
PWX-06153 td7crcrs.1        I=000000000000 D=000000000000 U=000000000004
PWX-06182 Totals   12/05/17 15:20:37 I=000000000008 D=000000000001 U=000000000008 C=000000000015 Log=00/01/01 00:00:00.00
In this example, the PWX-06153 messages show the number of inserts, deletes, and updates by registration for a Reader task run. The PWX-06181 messages provides totals for each 10-minute interval, and the PWX-06182 message provides totals for the entire run. Messages PWX-06181 and PWX-6182 report the log position with zeroes because the ECCR reads changes from the Datacom CDC tables instead of from database log files.
The following messages are printed if you add
minutes
 to the STATISTICS command, for example,
F
eccr_task_name
,STATISTICS 2
: 
PWX-07809 Statistics interval. New interval command accepted
PWX-07810 Statistics interval subtask, collection interval updated to 2 minute(s)
PWX-06181 Interval 12/05/17 15:48:14 I=000000000001 D=000000000000 U=000000000000 C=000000000001 Log=00/01/01 00:00:00.00
PWX-06181 Interval 12/05/17 15:50:14 I=000000000000 D=000000000001 U=000000000002 C=000000000003 Log=00/01/01 00:00:00.00

Usage Notes

  • Before you specify the
    STATISTICS
    minutes
     command to change the interval at which statistics are reported, you must either specify CAPT_STATS=Y in the RUNLIB(ECCRDCMP) member or issue the STATISTICS ON command.
  • The interval that is specified in
    STATISTICS
    minutes
     command overrides any interval that is specified in the CAPT_STATS_INTVL parameter. In the message output, PWX-07809 reports the new interval that is set by the STATISTICS command.
  • The interval value cannot be 0. If you enter the command
    STATISTICS 0
    , PowerExchange issues error message PWX-07808. If you set the CAPT_STATS_INTVL parameter to 0 in the RUNLIB(ECCRDCMP) member, PowerExchange issues the error message PWX-00967.
  • If you set the CAPT_STATS_TERSE parameter to N in the RUNLIB(ECCRDCMP) member and then run STATISTICS SINCE TERSE, the TERSE option overrides the CAPT_STATS_TERSE setting for the SINCE period.
0 COMMENTS
We’d like to hear from you!