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.5
  • 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 IMS log-based ECCR captured. The messages are printed to the DTLLOG and DTLOUT data sets.
The IMS log-based ECCR STATISTICS command is supported only for the ECCR DTLCCIMX program that works with the DBRC API. PowerExchange supplies the DTLCCIMX program for IMS 10 and later.
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 SLDS. The ECCR always prints capture statistics at the end of its run.
For the ECCR to print statistics for each SLDS, you must set the CAPT_STATS parameter to Y in the RUNLIB(CAPTIMS) member or run the ECCR STATISTICS ON command.

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_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 PWX-06153 statistics messages are printed each time the ECCR finishes processing a SLDS: 
F 
eccr_task_name
,STATISTICS {OFF|ON}
In all of these commands,
eccr_task_name
 is required. This variable represents the name of the IMS 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 SLDS during the interval. The message also reports the position in the SLDS 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 SLDS 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 SLDS and closes it. The PWX-06153 messages report the number of inserts, deletes, and updates that were processed for each registered source, grouped by SLDS. 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=1 is specified. 
PWX-06967 ECCR starting at IMS log time 12/04/08 12:00:00.000000 (YY/MM/DD HH:MM:SS.NNNNNN). Record count=0                               
PWX-07805 Statistics interval subtask started, collection interval 1 minute(s)                                                            
PWX-06118 Registration loaded: DBName: IMSZ RegName: root.1 Creator: IMSDBASE Table: ROOT 
PWX-06118 Registration loaded: DBName: IMSZ RegName: xlev2.1 Creator: XMSDBASE Table: LEV2                                                                                                
PWX-07703 IMS ECCR, ECCR, Fri Apr 13 14:24:40.956 2012, Registration read completed.                                                      
PWX-06940 Batch  logs: Initial query with StartTime=<2012099F130958700000000C> loc=<SPEC> SSID=<*>.                                       
PWX-07261 The IMS ECCR will use offline log IMS123.ABCDEF.IEFRDER.G0024V00                                                               
PWX-07262 The IMS ECCR will use offline log data set with start time C963AE40AA3E0000 2012.099 13:09:58.70                                
PWX-07280                                             and   end time C963AE412F0E0000 2012.099 13:09:59.24.                               
PWX-07261 The IMS ECCR will use offline log IMS123.ABCDEF.IEFRDER.G0025V00                                                               
PWX-07262 The IMS ECCR will use offline log data set with start time C963AE572BF60000 2012.099 13:10:22.30                                
PWX-07280                                             and   end time C963AE5845F18000 2012.099 13:10:23.45.                                                         
PWX-06941 Online logs: Initial query with StartTime=<000000000000000000000000> loc=<SPEC> SSID=<IMS1>.     
PWX-07272 The IMS ECCR is processing log data set IMS123.ABCDEF.IEFRDER.G0024V00.                                                          
PWX-06152 IMS SLDS File IMS123.ABCDEF.IEFRDER.G0024V00  closed with some records processed. Progress since last display:                   
PWX-06153 root.1            IMSDBASE ROOT      I=000000000005 D=000000000000 U=000000000000                                                 
PWX-06153 xlev2.1           XMSDBASE LEV2      I=000000000000 D=000000000000 U=000000000000                                                
PWX-07272 The IMS ECCR is processing log data set IMS123.ABCDEF.IEFRDER.G0025V00.                                                          
PWX-06152 IMS SLDS File IMS123.ABCDEF.IEFRDER.G0025V00  closed with some records processed. Progress since last display:
PWX-06153 root.1            IMSDBASE ROOT      I=000000000000 D=000000000001 U=000000000001                                                 
PWX-06153 xlev2.1           XMSDBASE LEV2      I=000000000001 D=000000000000 U=000000000000                                                                                                               
PWX-06181 Interval 12/04/13 14:25:35           I=000000000006 D=000000000001 U=000000000001 C=000000000002 Log=12/04/12 15:15:34.02         
PWX-06181 Interval 12/04/13 14:26:35           I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/04/12 15:15:34.02         
PWX-06181 Interval 12/04/13 14:27:35           I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/04/12 15:15:34.02                                                                    
PWX-06179 IMS ECCR Run complete. Totals for this run:                                                                                        
PWX-06153 root.1            IMSDBASE ROOT      I=000000000005 D=000000000001 U=000000000001                                                  
PWX-06153 xlev2.1           XMSDBASE LEV2      I=000000000001 D=000000000000 U=000000000000                                       
PWX-06182 Totals   12/04/13 14:36:09           I=000000000006 D=000000000001 U=000000000001 C=000000000008 Log=12/04/12 15:15:34.02          
PWX-07291 ECCR is shutting down after reading the IMS log to 12/04/12 15:15:34.026000                                                        
PWX-07807 Statistics subtask ended, cycle count =  3
In this example, the PWX-06153 messages show the number of inserts, deletes, and updates by registration for each SLDS and for the entire ECCR run. The PWX-06181 messages provides totals for each 1-minute interval, and the PWX-06182 message provides totals for the entire ECCR run.
The following messages are printed if you add
minutes
 to the STATISTICS command, for example,
F
eccr_task_name
,STATISTICS 1
: 
PWX-07809 Statistics interval. New interval command accepted
PWX-07810 Statistics interval subtask, collection interval updated to 1 minute(s)       
...
PWX-06181 Interval 12/05/22 15:12:35           I=000000000001 D=000000000001 U=000000000000 C=000000000002 Log=12/05/22 09:26:46.64
PWX-06181 Interval 12/05/22 15:13:35           I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/05/22 09:26:46.
The following messages are printed if you use the STATISTICS SINCE command to print statistics since the last execution of the STATISTICS command: 
PWX-06183 SnceLast 12/04/13 14:32:35                                                                                                        
PWX-06153 root.1            IMSDBASE ROOT      I=000000000000 D=000000000000 U=000000000000                                                 
PWX-06153 xlev2.1           XMSDBASE LEV2      I=000000000000 D=000000000000 U=000000000000                                     
PWX-06184 SnceLast 12/04/13 14:34:51           I=000000000000 D=000000000000 U=000000000000 C=000000000000 Log=12/04/12 15:15:34.02
The following messages are printed if you use the STATISTICS ON command to print statistics by SLDS and for the entire run: 
PWX-07272 The IMS ECCR is processing log data set IMS1210.SLDSP.IMSC.D12135.T1318291.V03.                                            
PWX-06152 IMS SLDS File IMS1210.SLDSP.IMSC.D12121.T1318291.V03  closed with some records processed. Progress since last display:     
PWX-06153 d002cmpl.1         DTLD002 *COMPLEX  I=000000000013 D=000000000000 U=000000000000                                          
PWX-06153 d002root.1         DTLD002 ROOT      I=000000000040 D=000000000000 U=000000000000                                          
PWX-06153 d002seg1.1         DTLD002 SEG1      I=000000000040 D=000000000000 U=000000000000                                          
PWX-06153 d002seg2.1         DTLD002 SEG2      I=000000000013 D=000000000000 U=000000000000                                          
PWX-07272 The IMS ECCR is processing log data set IMS1210.SLDSP.IMSC.D12356.T0723336.V03.                                            
PWX-06152 IMS SLDS File IMS1210.SLDSP.IMSC.D12143.T0723336.V03  closed with some records processed. Progress since last display:     
PWX-06153 d002cmpl.1         DTLD002 *COMPLEX  I=000000000007 D=000000000020 U=000000000000                                          
PWX-06153 d002root.1         DTLD002 ROOT      I=000000000043 D=000000000077 U=000000000000                                          
PWX-06153 d002seg1.1         DTLD002 SEG1      I=000000000135 D=000000000157 U=000000000000                                          
PWX-06153 d002seg2.1         DTLD002 SEG2      I=000000000007 D=000000000020 U=000000000000   
PWX-06179 IMS ECCR Run complete. Totals for this run:                                                                                    
PWX-06153 d002cmpl.1         DTLD002 *COMPLEX  I=000000000080 D=000000000080 U=000000000000                                              
PWX-06153 d002root.1         DTLD002 ROOT      I=000000000332 D=000000000308 U=000000000000                                              
PWX-06153 d002seg1.1         DTLD002 SEG1      I=000000000700 D=000000000628 U=000000000000                                              
PWX-06153 d002seg2.1         DTLD002 SEG2      I=000000000080 D=000000000080 U=000000000000                                              
PWX-06182 Totals   12/05/22 07:34:26           I=000000001490 D=000000001370 U=000000000000 C=000000000237 Log=12/05/22 07:24:05.20      
PWX-07291 ECCR is shutting down after reading the IMS log to 12/05/22 07:24:05.207000

Usage Notes

  • PowerExchange supports the STATISTICS command only for the ECCR DTLCCIMX program, which is available for IMS 10 and later.
  • 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 DBMOVER configuration 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(CAPTIMS) configuration member, PowerExchange issues the error message PWX-00967.
  • If you set the CAPT_STATS_TERSE parameter to N in the RUNLIB(CAPTIMS) 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!