Skip to main content


PK95922: SUPPORT TO ALLOW USERS TO EXTRACT STATISTICS FROM AN SMF FILE DIRECTLY INTO A CSV FILE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Support to allow users to extract statistics from an SMF file
    directly into a CSV file.
    This enhancement will allow users to extract CICS TS, CICS
    Server and CICS TG statistics from an SMF file directly into a
    CSV file, rather than having to first load the data into an HDB
    and then perform the extract from the HDB.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of CICS PA v3.1                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following are addressed:            *
    *                                                              *
    *                        1. This APAR introduces support for   *
    *                           extraction of Statistics data      *
    *                           directly from SMF file into        *
    *                           delimited text file using a new    *
    *                           Report Set report.                 *
    *                                                              *
    *                        2. CICS TS statistics for WebSphere   *
    *                           MQ Connections has renamed field   *
    *                           "Callback routine invocations" to  *
    *                           "Messages Consumed", and this APAR *
    *                           replaces the old name with the new *
    *                           name in all Statistics functions.  *
    *                                                              *
    *                        3. In addition, this APAR corrects    *
    *                           the following issues:              *
    *                                                              *
    *                           a. Intermittent ABEND0C4 in        *
    *                              CPAHDRPT +3A4B2 when Statistics *
    *                              Alert report does not generate  *
    *                              any alerts.                     *
    *                                                              *
    *                           b. ListX command LIMIT operand     *
    *                              generated incorrectly for clock *
    *                              fields.                         *
    *                                                              *
    *                           c. HDB Template Selection Criteria *
    *                              overrides HDB Selection         *
    *                              Criteria.                       *
    *                                                              *
    *                           d. Statistics HDB Extract ABEND0C4 *
    *                              in module UNKNOWN when          *
    *                              PARM='UPPER' is specified.      *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following items are addressed:
    
       1. This APAR introduces support for extraction of Statistics
          data directly from SMF file into delimited text file using
          a new Report Set report.
          Prior to this APAR, the only means of extracting
          Statistics data was by loading it into a Statistics HDB
          and then extracting the data from the HDB.
    
       2. CICS Transaction Server statistics for WebSphere MQ
          Connections has renamed field "Callback routine
          invocations" to "Messages Consumed". This APAR replaces
          the old name with the new in all Statistics functions.
    
       3. In addition, this APAR corrects the following issues:
    
          a. Intermittent ABEND0C4 in CPAHDRPT +3A4B2 when
             Statistics Alert report does not generate any alerts.
    
          b. ListX command LIMIT operand generated incorrectly for
             clock fields resulting in the LIMIT operand being
             ignored and all transactions reported.
    
          c. HDB Template Selection Criteria overrides HDB Selection
             Criteria resulting in only Template Selection Criteria
             being applied during HDB Load.
    
          d. Statistics HDB Extract ABEND0C4 in module UNKNOWN when
             PARM='UPPER' is specified.
    
    Summary of Changes
    
       1. Report Sets Extract category has been enhanced to include
          a new extract of statistics data directly from SMF files.
          This new function allows the extraction of statistics data
          to delimited text files for purpose of importing the
          Statistics class data into PC spreadsheet or database
          tools for further detailed analysis and reporting.
          When transferred to a workstation file the exported
          statistics class data is available to PC applications such
          as Lotus 1-2-3.
    
          As part of this change the Report Set Extract Export has
          been renamed to Extract Performance.
    
       2. Statistics for WebSphere MQ Connections field "Callback
          routine invocations" has been renamed to "Messages
          Consumed" to conform with CICS Transaction Server change.
    
       3. The following issues have been corrected:
    
          a. Statistics Alert report no longer abends when no alerts
             are generated.
    
          b. ListX command LIMIT operand is now generated correctly.
    
          c. HDB Template Selection Criteria no longer overrides
             HDB Selection Criteria thus only required records
             are loaded into the HDB.
    
          d. Statistics HDB Extract no longer abends when
             PARM='UPPER' is specified.
    

Problem conclusion

Temporary fix

Comments

  • Support is introduced for extraction of Statistics data directly
    from SMF file into delimited text file using a new Report Set
    report.
    
    The field name "Callback routine invocations" has been
    renamed to "Messages Consumed" in all Statistics functions
    because CICS TS statistics for WebSphere MQ Connections has
    renamed those fields.
    
    Also, a number of issues are corrected as described above.
    

APAR Information

  • APAR number

    PK95922

  • Reported component name

    CICS PERF ANALY

  • Reported component ID

    5655U8700

  • Reported release

    310

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-10

  • Closed date

    2009-10-28

  • Last modified date

    2009-11-10

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK51452 UK51465

Modules/Macros

  •    CPAALTMF CPACMDMF CPAC0380 CPAERLST CPAG02
    CPAHDEST CPAHDLOD CPAHDSTA CPAHDXTT CPAHSAPI CPAHSCT1 CPAHSCT2
    CPAHSCT3 CPAHSCT4 CPAHSCT5 CPAIBM$0 CPAIBM$1 CPAIBM$2 CPAIBM$3
    CPAPEXP  CPAQFLS0 CPAQFLX0 CPAQFPDD CPAQFPDR CPAQFPDS CPAQFRFE
    CPAQFRFL CPAQFSU0 CPAQHSF2 CPAQML1  CPAQML2  CPAQPRA1 CPAQPRA2
    CPAQPRA3 CPAQREXL CPAQRFTY CPAQRSEX CPAQRSSR CPAQRSSS CPAQRSSX
    CPAQRSS2 CPAQRSXL CPAQSSXP CPAQTUEX CPAQTULE CPAQTUTZ CPAQTUXC
    CPAQTUXS CPAQTUXX CPAQZ049 CPAQZ050 CPAQZ051 CPARSDEC CPARSDEF
    CPARSEV  CPARSEX  CPARSEXL CPARSJCL CPARSPUT CPARSSAV CPARSSR
    CPARSSRT CPARSSR1 CPARSSR2 CPARSSR3 CPARSSX  CPARSSXL CPASMAP2
    CPASMAP3 CPASMAP4 CPASMAP5 CPAS074A CPAXPTMF CPAXTRST H24D310J
    LNKRSSRT LNKXTRST MSGG02   QFPDDJ   S074A039 TRANSMEM
    

Fix information

  • Fixed component name

    CICS PERF ANALY

  • Fixed component ID

    5655U8700

Applicable component levels

  • R31C PSY UK51456

       UP09/11/10 I 1000

  • R31E PSY UK51465

       UP09/11/10 I 1000

  • R31K PSY UK51469

       UP09/11/10 I 1000

  • R310 PSY UK51452

       UP09/11/10 I 1000

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page

Please take a moment to complete this form to help us better serve you.

This material provides me with the information I need.






This material is clear and easy to understand.






Did the information help you to achieve your goal?

What updates, improvements, or related information would you like to see in this document?

Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.


Input the verification number to submit feedback:



Maintenance Window

Unscheduled Maintenance Window

There is no unscheduled maintenance scheduled at this time.

Document information

Product categories:

Software

Host Transaction Processing

Transaction Tools

CICS Performance Analyzer


Software version:

310


Reference #:

PK95922


IBM Group:

Software Group


Modified date:

2009-11-10

Translate my page