Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.
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.5.4
  • 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 z/OS 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 IDMS 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 an IDMS log. The ECCR always prints capture statistics at the end of its run.
For the ECCR to report statistics for each IDMS log, you must add the CAPT_STATS=Y parameter to the RUNLIB(ECCRIDLP) member or specify the STATISTICS ON command after the ECCR starts.

Syntax

Use the following command syntax to print message PWX-06182, which reports the 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 the 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 PWX-06153 statistics messages are printed each time the ECCR finishes processing an IDMS log: 
F 
eccr_task_name
,STATISTICS {OFF|ON}
In all of these commands,
eccr_task_name
 is required. This variable represents the name of the IDMS 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 log during the interval. The message also reports the position in the log 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 an IDMS log 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 an IDMS log and closes it. The PWX-06153 messages report the number of inserts, deletes, and updates that were processed for each registered source, grouped by log. 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 IDMS LB CDC, ECCR, Mon May 28 13:57:48.590 2012, Registration read started.
PWX-06118 Registration loaded: DBName: QACLGSID RegName: stuoflat.1 Creator: stuoss01 Table: abc_STUODENT_FLAT
PWX-06118 Registration loaded: DBName: QACLGSID RegName: stupflat.1 Creator: stupss01 Table: abc_STUPDENT_FLAT
PWX-06118 Registration loaded: DBName: QACLGSID RegName: stupf100.1 Creator: stups100 Table: abc_STUPDENT_FLAT
PWX-07703 IDMS LB CDC, ECCR, Mon May 28 13:57:52.699 2012, Registration read completed.
PWX-07991 GLCI did not return any extended Info. Cold Start implied
PWX-07805 Statistics interval subtask started, collection interval 10 minute(s)
PWX-07701 IDMS LB CDC, ECCR, Mon May 28 13:58:12.270 2012, Initialisation completed.
PWX-07813 IDMS LB CDC, Reader Task First-----------> captured data 12/03/01 10:53:38.116809.
PWX-07814 IDMS LB CDC, Reader Task First-----------> records processed 0000000002.
Closed journal/log after processing.... at 14:07:14:5022 on mon 28/05/2012, blocks = 0000000509, records = 0000022061
IDMS.Q18SP0.JOURNAL.GDG.G0024V00
PWX-06153 stuoflat.1 I=000000000190 D=000000000000 U=000000000000
PWX-06153 stupflat.1 I=000000000204 D=000000000000 U=000000000000
PWX-06153 stupf100.1 I=000000000265 D=000000000000 U=000000000000
Opened journal/log for processing...... at 14:07:15:8995 on mon 28/05/2012
IDMS.Q18SP0.JOURNAL.GDG.G0025V00
Closed journal/log after processing.... at 14:07:27:6910 on mon 28/05/2012, blocks = 0000000507, records = 0000023389
IDMS.Q18SP0.JOURNAL.GDG.G0025V00
PWX-06153 stuoflat.1 I=000000000427 D=000000000000 U=000000000000
PWX-06153 stupflat.1 I=000000000421 D=000000000000 U=000000000000
PWX-06153 stupf100.1 I=000000000429 D=000000000000 U=000000000000
PWX-06181 Interval 12/05/28 14:14:17 I=000000000868 D=000000000000 U=000000000000 C=000000000000 Log=12/03/01 11:08:35.67
PWX-06181 Interval 12/05/28 14:24:17 I=000000000868 D=000000000000 U=000000000000 C=000000000000 Log=12/03/01 11:08:35.67
PWX-07730 IDMS LB CDC, ECCR, Tue May 29 13:00:25.612 2012, No active units of work found at shutdown.
PWX-07967 DTLCCIDL shutting down having read to ......
PWX-07812 Latest time processed 12/03/01 11:08:35.679115
Records processed 002939 (IDMS capture)
PWX-07807 Statistics subtask ended, cycle count = 20
PWX-07813 IDMS LB CDC, Reader Task Shutdown--------> captured data 12/03/01 11:08:35.679115.
PWX-07814 IDMS LB CDC, Reader Task Shutdown--------> records processed 0000300939.
PWX-06153 stuoflat.1 I=000000000617 D=000000000000 U=000000000000
PWX-06153 stupflat.1 I=000000000625 D=000000000000 U=000000000000
PWX-06153 stupf100.1 I=000000000694 D=000000000000 U=000000000000
PWX-06182 Totals 12/05/29 13:00:37 I=000000001936 D=000000000000 U=000000000000 C=000000002047 Log=12/03/01 11:08:35.67
PWX-07971 Collector closing down (IDMS Capture)
In this example, the PWX-06153 messages show the number of inserts, deletes, and updates by registration for each IDMS log. The PWX-06181 messages provides totals for each 10-minute interval, and the PWX-06182 message provides totals for the entire run.
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/28 20:41:29 I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/03/01 11:08:35.67
PWX-06181 Interval 12/05/30 00:41:30 I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/03/01 11:08:35.67

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