Mainframe Application Tuner

 View Only

CA Mainframe Application Tuner - New exciting enhancements available

  • 1.  CA Mainframe Application Tuner - New exciting enhancements available

    Broadcom Employee
    Posted Jul 11, 2019 09:02 AM
      |   view attached

    On behalf of CA Mainframe Application Tuner development team, I am happy to announce another batch of exciting new features for CA MAT v12.

    What is new and available for you? 

    • DB2 WLM managed stored procedures (External Stored Procedures and User Defined Functions) support
    • DB2 WLM JAVA AGENT support
    • CSECT DESCRIPTION enhancement phase II
    • Sampling architecture improvements – PC and SVC

    Continue reading for more detailed descriptions.

     

    DB2 WLM managed stored procedures (ESPs and UDFs):

    Feature brings ability of CA MAT v12 to measure and obtain relevant data for WLM managed External Store Procedures and User Defined Function, written in ASM REXX C COBOL PL/I, enabling more profound tuning opportunity identification.

     

    In order to collect the data simply measure WLM spawned address space via standard monitor definition (see fig. 1) and then analyze the collected data under Interactive Analysis option 10 -DB2 View (see fig. 2 and 3).
     

    Fig.1 – Example Monitoring Criteria setup for WLM AS measurement.
    Fig.1 – Example Monitoring Criteria setup for WLM AS measurement.

     

    Fig 2 - WLM related data display

     

    Fig 3 - WLM related data display

    Fig. 2 and 3 - WLM related data display

    Tip: Ensure you have all relevant columns in the analysis screen visible. Using advanced command CUST you can enable / disable / reorder / filter your view to your needs.

     This Enhancement can be obtained via regular maintenance stream under #SO09066

     For more information see documentation of:  Analysis for WLM

     

     

    DB2 WLM JAVA AGENT support:

    This enhancement extends previous functionality of WLM data collection (see above) of JAVA WLM stored procedures support. Data can be found and analyzed on JAVA Interactive Analysis option 12 – Java Virtual Machine view (see fig. 4).

    To enable data collection using CA MAT JAVA AGENT it is enough to add javaagent option to jvmopt on USS and a LIBPATH in envfile of targeted DB2 subsystem. By this AGENT is automatically triggered when SP is run on DB2 spawned WLMJ (JAVA) address space. (e.g. see fig. 5)

     

    Fig 4 – PC line command on DelayView (Opt. 2) in interactive Analysis

     Fig. 4 – JAVA information collected by WLM JAVA AGENT – SQL / CLASSES up to statement level

     

    Fig 5 – JAVA WLM AGENT trace in the log of WLMJ AS
     Fig. 5 – JAVA WLM AGENT trace in the log of WLMJ AS

      

    To obtain DB2 WLM JAVA AGENT support apply following enhancement PTF: #SO08989

    For more information see documentation of:  Analysis for WLM

     

    What does CSECT DESCRIPTION II feature contain:

    This feature is continuation of our effort to bring more comprehensive and contextual information for CA MAT v12 during data analysis time. In this phase we have added and updated thousands of CSECT descriptors for IDMS / ACF / TSS / DATACOM & IDEAL as well as IBM DB2 / MQ  and CICS. This enhancement can be obtained via #SO08951

     

     

    Sampling architecture improvements – PC and SVC

    This enhancement sees a reworking of the CA MAT sampling architecture. It brings the sampling mechanism more in line with recent development in hardware and software and adds features to display more information about your sampled application under PC Routine and SVC information categories thus help you to understand the causes of delays.

    • PC routine display

    Before our data was presented in aggregated way for most of Program Calls (PC) under PC CALL delay type. With the enhancement you can use new PC line command and expand the category for more granular and detailed information or update, display the service description (see fig. 6 and 7).

    Fig 6 – PC line command on DelayView (Opt. 2) in interactive Analysis
    Fig. 6 – PC line command on DelayView (Opt. 2) in interactive Analysis
    Fig 7 – PC line command on DelayView (Opt. 2) in interactive Analysis
    Fig. 7 – PC line command on DelayView (Opt. 2) in interactive Analysis


    • SVC information


    Prior to the enhancement we would attribute the SVC activity solely to the application. With the enhancement installed you have the information split from application and attributed to particular SVC handler where you can drill down using line command C for callerid information and subsequently L for display listing information to pin point a location where particular SVC was used.  Other information has been supplemented like:

      • SVC number
      • SVC Module Name
      • SVC Type and Authorization
      • SVC Attribute
      • SVC Locks

    Fig 8 – Separate display of SVC handler with ability to drill down via callerid command

    Fig 8 – Separate display of SVC handler with ability to drill down via callerid command

      

    This enhancement can be obtained through application of following enhancement PTF: #SO08560

    For more information on the SVC support, see Display Delay Locations (DelayView) and in the same manner for PC Routine support, see Display Program Calls (DelayView).

     

     _____________________________________________________________________      

     

    More information about CA Mainframe Application Tuner V12, see the release notes in CA MAT V12 documentation.

    _____________________________________________________________________      

     

    Thank you for choosing CA Mainframe Application Tuner to improve your application performance. Should you be interested in live demo? Update on product direction or POC? Feel free to contact us directly. Together with Product Manager Ekaterina Tumanova (Ekaterina.Tumanova@broadcom.com), we are always interested in your thoughts and feedback.



    ------------------------------
    Petr Klomfar (Petr.Klomfar@broadcom.com)
    Product Owner of CA MAT

    ------------------------------

    Attachment(s)