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.4.0 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

Release Guide

Release Guide

Back Next

Enhanced Monitoring Statistics for the PowerExchange Logger for Linux, UNIX, and Windows

Enhanced Monitoring Statistics for the PowerExchange Logger for Linux, UNIX, and Windows

PowerExchange 10.0 provides new commands for publishing enhanced PowerExchange Logger monitoring statistics on demand. PowerExchange also provides a new PowerExchange Logger parameter to enable collection of these monitoring statistics and optionally print them at a specific interval. Use these statistics to monitor PowerExchange Logger processing status and computer resource usage.
The statistics are written to the PowerExchange message log and displayed on screen.
Before you can use the new commands, you must specify the new STATS=(MONITOR) parameter in the PowerExchange Logger pwxccl.cfg configuration file to enable collection of the monitoring statistics.
If the PowerExchange Logger runs in the foreground, issue the DL or DG command from the command line on the system where the PowerExchange Logger runs. If the PowerExchange Logger runs in background mode or you want to issue the commands from a remote Linux, UNIX or Windows system, use the pwxcmd program to issue the displaystatus -tp {logger|groups} command.
The DL (or DS) command or pwxcmd displaystatus -tp logger command prints the following statistics for a PowerExchange Logger process and its tasks: 
PWX-26011 Command handler received command "DS"
PWX-00723 Command <display L stats> succeeded
PWX-37130   PWXCCL pid = 7144       Writer status = Reading or waiting for source data
PWX-37134   CPU Time =    0:00:02.574016
PWX-37131   Memory  (Current/Total/Maximum)
PWX-37132    Controller: (981/983/1849) KB    Command Handler: (673/674/708) KB    Writer: (5127/5147/5181) KB
PWX-37135   Status  7144                  Totals  I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37136    CurrFileOpened : 2015-08-11 13:20:39 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37137     Active Cycle  : 2015-08-11 13:21:01 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
The DG command or pwxcmd displaystatus -tp groups command prints the following statistics for each PowerExchange Logger group definition: 
PWX-26011 Command handler received command "DG"
PWX-37138   Grp: dtld004 Regs=1 IUD=000000000000 C=000000000000 Unflushed=000000000000
PWX-37138   Grp: dtld003 Regs=2 IUD=000000000470 C=000000000028 Unflushed=000000000000
PWX-37138   Grp: dtld002 Regs=2 IUD=000000003276 C=000000000196 Unflushed=000000000000
If no PowerExchange Logger group definitions exist, the DG or pwxcmd displaystatus -tp groups command prints the following statistics, as if all registrations were in one group: 
PWX-26011 Command handler received command "DG"
PWX-37138   Grp: c:\pwx\capture/condenseO Regs=5 IUD=000000032292 C=000000001931 Unflushed=000000034223
PWX-37139       FirstRec=2015-05-22 13:59:10.603648  Open file=c:\pwx\capture/condenseO.CND.CP150707.T1816001
PWX-37140       BeginSeq =000000009DE6000000000000000088D800000000 BeginRstrt =D4C9C7D340400000000037DA00000000
PWX-37141       LastSeq  =0000015874380000000000000158728600000000
PWX-37142       CommitSeq=000001589B2400000000000001589B2400000000 CommitRstrt=D4C9C7D340400000000037DA00000000
Also, you can configure the PowerExchange Logger to print monitoring statistics at a specific interval by including the optional
interval
 subparameter in the STATS parameter in the pwxccl.cfg file. In this case, the PowerExchange Logger displays an abbreviated form of the DL command output on screen to avoid flooding the screen with messages over time. For example: 
PWX-37132    Controller: (981/983/1849) KB    Command Handler: (0/0/34) KB    Writer: (5127/5147/5181) KB
PWX-37135   Status  7144                  Totals  I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37136    CurrFileOpened : 2015-08-11 13:20:39 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
PWX-37137     Active Cycle  : 2015-08-11 13:21:01 I=000000024344 U=000000000000 D=000000024336 C=000000004004 Total=000000052684
For more information, see the "Monitoring CDC Sessions" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
 and the "PowerExchange Logger for Linux, UNIX, and Windows Commands" chapter in the
PowerExchange Command Reference
.
0 COMMENTS
We’d like to hear from you!