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 Adabas log-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 finishes processing a PLOG. The ECCR always prints capture statistics at the end of its run.
For the ECCR to print statistics for each PLOG, you must specify the CAPT_STATS=Y parameter in the RUNLIB(ADAECRP1) 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 for 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 PWX-06153 statistics messages are printed each time the ECCR finishes processing a PLOG: 
F 
eccr_task_name
,STATISTICS {OFF|ON}
In all of these commands,
eccr_task_name
 is required. This variable represents the name of the Adabas log-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 from a PLOG during the interval. The message also reports the position in the PLOG up to which changes were captured. 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 a PLOG is closed. 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 each time the ECCR finishes processing a PLOG and closes it. The PWX-06153 messages report the number of inserts, deletes, and updates that were processed for each registered source, grouped by PLOG. 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 the SINCE 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.

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(ADAECRP1) 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(ADAECRP1) member, PowerExchange issues the error message PWX-00967.
  • If you set the CAPT_STATS_TERSE parameter to N in the RUNLIB(ADAECRP1) 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!