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
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

Reference Manual

Reference Manual

Back Next

Example Reports

Example Reports

Use the example reports to determine which reports best suit your requirements and to understand the information that each report presents.
Each report shows statistics by record. The
Record
 column lists the relative record numbers of the records in the input SMF archived data sets. You can use these record numbers to link information in different reports. If a record number is not listed in a report, the record contains no information for the report. If a record number is repeated in a report, such as the Access Method Statistics report, multiple instances of a SMF section might occur in the SMF record.

Example 1. Time and CPU Statistics

Example report: 
                                                 Time and CPU Statistics                                     Page: 1                
 Record Type       Proc_Id Job_Name User_Id  Start_Time           End_Time             CPU_Time_1  CPU_Time_2  Version               
 ______ __________ _______ ________ ________ ____________________ ____________________ ___________ ___________ __________                       
 2126   PWX Intvl                            2018 03/28 17:33:08                          0.018992    0.471135 10.2.0                
 2127   Cli Intvl  73309   A02DTLSN xxINFAxx 2018 03/28 17:33:25                          0.031312    5.225357 10.2.0                
 2128   Cli Intvl  73313   A02DTLSN ausqa    2018 03/28 17:37:25                          2.861607    5.504249 10.2.0                
 2129   Cli Intvl  73315   A02DTLSN AUSQA    2018 03/28 17:37:44                         21.006851   28.564011 10.2.0                
 2289   Cli End    73318   A02DTLSN AUSQA    2018 03/28 17:39:19  2018 03/28 17:39:33     0.056402    0.056402 10.2.0                
 2561   PWX Intvl                            2018 03/28 17:33:08                          0.022712    0.493847 10.2.0                
 2562   Cli Intvl  73309   A02DTLSN xxINFAxx 2018 03/28 17:33:25                          0.039725    5.265082 10.2.0                
 2563   Cli Intvl  73313   A02DTLSN ausqa    2018 03/28 17:37:25                          0.432298    5.936546 10.2.0                
 2564   Cli Intvl  73319   A02DTLSN AUSQA    2018 03/28 17:39:30                          0.031786    0.031786 10.2.0                
 2565   Cli Intvl  73315   A02DTLSN AUSQA    2018 03/28 17:37:44                          7.693156   36.257172 10.2.0                
 2696   Cli End    73320   A02DTLSN AUSQA    2018 03/28 17:40:26  2018 03/28 17:40:26     0.027886    0.027886 10.2.0                
 2999   Cli End    73321   A02DTLSN AUSQA    2018 03/28 17:41:05  2018 03/28 17:41:05     0.028508    0.028508 10.2.0                
 3025   PWX Intvl                            2018 03/28 17:33:08                          0.022894    0.516741 10.2.0                
 3026   Cli Intvl  73309   A02DTLSN xxINFAxx 2018 03/28 17:33:25                          0.031705    5.296787 10.2.0                
 3027   Cli Intvl  73313   A02DTLSN ausqa    2018 03/28 17:37:25                                      5.936546 10.2.0                
 3028   Cli Intvl  73319   A02DTLSN AUSQA    2018 03/28 17:39:30                                      0.031786 10.2.0                
 3029   Cli Intvl  73315   A02DTLSN AUSQA    2018 03/28 17:37:44                          2.280185   38.537354 10.2.0
Report fields:
  • Record
    . The relative record number of the SMF record within the input SMF archived data sets.
  • Type
    . The type of SMF record. Valid values are:
    • PWX Intvl
      . The PowerExchange interval record that contains the amount of CPU time that the PowerExchange Listener address space used, up to the end of the reporting interval.
    • Cli Intvl
      . The client interval record that contains the amount of CPU time that an active PowerCenter client session used, up to the end of the reporting interval.
    • Cli End
      . The client end record that contains the total amount of CPU time that the PowerCenter client session used, up to the end of the session.
  • Proc_ID
    . The unique process identifier that is assigned to a client connection.
  • Job_Name
    . The job name that is associated with the client.
  • User Id
    . The user ID that the client uses.
  • Start_Time
    . The start time of the PowerExchange Listener or client, depending on the Type of record.
  • End_Time
    . The ending time of the client connection to the PowerExchange Listener.
  • CPU_Time_1
    . The CPU time that was used up to the end of the current reporting interval. This value is reported if interval-based reporting is enabled in the STATS statement of the PowerExchange DBMOVER configuration file.
  • CPU_Time_2
    . The total CPU time that was used up to the end of the client session.
The CPU_TIME_1 value will match the CPU_TIME_2 value when the client session ends or the PowerExchange Listener connection ends.

Example 2. PowerCenter Session Information

Example report: 
                                                     PWC Information                                         Page: 1           
 Record Map_Name    Session_Id                                                                                                       
 ______ ___________ _________________________________________________________________________________________________
 1332               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1468   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1469               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1617               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1708               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna           
 1837   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1846   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsnc/s_2st_lim011_lim012_dsna           
 1847   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna           
 1848               i_mhvaix0264_ausqa/wfaccounts_ic/s_accounts_ic_to_accounts           
 1849               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna           
 1925               i_mhvaix0264_ausqa/wfaccounts_ic/s_accounts_ic_to_accounts           
 1998               i_mhvaix0264_ausqa/wfaccounts_fic/s_accounts_fic_to_accounts            
 2128   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna           
 2129               i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna           
 2289               i_mhvaix0264_ausqa/wfqaalltypes_fic/s_qaalltypes_fic_to_qaalltypes2           
 2563   lim012      i_mhvaix0264_ausqa/wf_2ST_lim011_lim012_dsna/s_2st_lim011_lim012_dsna
Report fields:
  • Record
    . The relative record number of the SMF record within the input SMF archived data sets.
  • Map_Name
    . The map name that the PowerCenter client uses. This value can be a data map or extraction map name.
  • Session_Id
    . The PowerCenter session ID.

Example 3. Access Method Statistics

Example report: 
                                                 Access Method Information                                   Page: 1                
                   File/Type                                                   ------ Rows ----- -------- Bytes ------               
 Record Access     Table                                                       Read     Written  Read       Written                  
 ______ __________ ___________________________________________________________ ________ ________ __________ __________               
 2129   DB2        CONNECTION                                                  0        0        0          0                        
 2129   DB2        ADA8421.LIM11_TGT                                           0        0        0          0                        
 2129   DB2        ADA8421.LIM11_TGT                                           0        4853     0          140427                   
 2129   DB2        ADA8421.LIM11_TGT                                           0        0        0          0                        
 2129   DB2        ADA8421.LIM12_TGT                                           0        0        0          0                        
 2129   DB2        ADA8421.LIM12_TGT                                           0        4921     0          141351                   
 2129   DB2        ADA8421.LIM12_TGT                                           0        0        0          0                        
 2129   DB2        ADA8421.LIM12_TGT                                           0        7918     0          225448                   
 2129   DB2        ADA8421.LIM11_TGT                                           0        7798     0          222586                   
 2289   DB2        CONNECTION                                                  0        0        0          0                        
 2289   DB2                                                                    0        0        0          0                        
 2563   CAPXRT     CONNECTION                                                  6075     0        0          0                        
 2563   CAPXRT     DTLTEMP.UOWCTRL_DTL___UOW___TABLE                           0        0        0          0                        
 2563   CAPXRT     d1dsna.lim011_LIM11                                         0        0        0          0                        
 2563   CAPXRT     d1dsna.lim012_LIM12                                         0        0        0          0                        
 2564   DB2        CONNECTION                                                  0        0        0          0                        
 2564   DB2                                                                    0        0        0          0                        
 2565   DB2        CONNECTION                                                  0        0        0          0                        
 2565   DB2        ADA8421.LIM11_TGT                                           0        0        0          0                        
 2565   DB2        ADA8421.LIM11_TGT                                           0        1773     0          51414                    
 2565   DB2        ADA8421.LIM11_TGT                                           0        0        0          0                        
 2565   DB2        ADA8421.LIM12_TGT                                           0        0        0          0                        
 2565   DB2        ADA8421.LIM12_TGT                                           0        1749     0          49958
Report fields:
  • Record
    . The relative record number of the SMF record within the input SMF archived data sets.
  • Access
    . The access method that the client session used to access the PowerExchange source.
  • File/Type or Table
    . The file name or table name that the access request used.
  • Rows Read
    . The number of rows that were read.
  • Rows Written
    . The number of rows that were written.
  • Bytes Read
    . The number of bytes that were read.
  • Bytes Written
    . The number of bytes that were written.

Example 4. Db2 for z/OS Statistics

Example report: 
 Record SSID Plan     Conn_Typ Auth_Id  Corr_Id  Stmts   Rows    SQLCODE RSNCODE Update Delete Insert CPU                            
 ______ ____ ________ ________ ________ ________ _______ _______ _______ _______ ______ ______ ______ ___________                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       24341   0       0       0      0      0         9.206862                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      32869  0        13.745912                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      0         0.003656                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       24198   0       0       0      0      0         9.068873                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      32949  0        13.629420                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      39355     9.477407                    
 3771   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      39170     9.568233                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      0         0.005295                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       29817   0       0       0      0      0        11.241923                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      40177  0        16.763763                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      0         0.003656                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       29635   0       0       0      0      0        11.065903                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      40189  0        16.585022                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      46561    11.353901                    
 4062   DSNA AUBK1020 CAF      AUSQA    PWX73315 1       0       0       0       0      0      46576    11.511835
Report fields:
  • Record
    . The relative record number of the SMF record within the input SMF archived data sets.
  • SSID
    . The Db2 subsystem ID.
  • Plan
    . The Db2 plan name that is used to access the Db2 for z/OS source.
  • Conn_Typ
    . The type of Db2 attachment facility that the client session used to connect to Db2. Valid values are:
    • CAF
      . Call attachment facility.
    • RRSAF
      . Resource Recovery Services attachment facility.
  • Auth_Id
    . The Db2 authorization ID that PowerExchange used for the client session.
  • Corr_Id
    . The Db2 correlation ID that PowerExchange used for the client session.
  • Stmts
    . The number of SQL statements that the session processed.
  • Rows
    . The number of rows that Db2 returned.
  • SQLCODE
    . The Db2 code.
  • RSNCODE
    . The Db2 reason code for the specified SQLCODE.
  • Update
    . The number of updates that were processed.
  • Delete
    . The number of deletes that were processed.
  • Insert
    . The number of inserts that were processed.
  • CPU
    . The amount of Db2 CPU time that was charged to the client request.
0 COMMENTS
We’d like to hear from you!