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

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!