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. 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 – 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
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.
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. 7 – PC line command on DelayView (Opt. 2) in interactive Analysis
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
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
------------------------------