37. Use Cases Leveraging Db2 Accounting Data to Optimize Your Environment

August 16 | 1 PM CT | 2 PM ET
Presenters: Sally Mir and Todd Havekost

Db2 Accounting data can provide a very rich source of insights into your workloads and performance. This webinar will present several real-life examples where good visibility into Accounting data enables issues to be detected and resolved or insights to be derived.

Examples will include:

  • Ways to get to the bottom of what is going on in the “wild wild west” of your DDF workloads
  • How to isolate and resolve RID issues to enhance availability and performance
  • Interpreting metrics associated with DBATs and how to optimize them
  • Understanding the many types of suspension times and how to decipher them
  • Clear visibility into the benefits achieved through a (in this case very successful) SQL tuning change

This webinar will equip you to enhance the value and insights you can derive from your own Db2 Accounting data.

        
    

Save Your Seat

        


    

Previous zAcademy Sessions

1. Imagine How Much You Can Learn from SMF Data

Presenter: Todd Havekost

The mainframe produces a set of metrics far superior to any other platform. Unfortunately, there are significant barriers to unleashing the learning value of this SMF data.

Attend this session to learn how rapidly you could leverage easy visibility into RMF and SMF data to expand your understanding of how the z/OS ecosystem operates, and renew your passion for the disciplines of performance analysis or infrastructure support!

Request link to watch recording

 

2. “What Am I Waiting For” is a basic performance session for anyone

Presenter: John Baker

The performance analyst is that rare breed that simply must know – in excruciating detail – what makes things take so long, whether the “thing” is a DDF transaction from the web or a line at the store.

Regardless of your job, we all hate to wait, so understanding these principles can be quite satisfying. Take a stroll with John as we shed some light on these concepts. No degrees, certifications, or programming necessary – this intro session is for everyone.

Request link to watch recording

 

3. Reining in HSM

Presenter: Jack Opgenorth

You’ve already heard some good advice on optimizing HSM, but what about the new z15 features? What about your different tape compression options? Or changing your storage management strategies?

We’ll use some comparative data to outline some opportunities to consider going forward. Previously referenced recommendations will be emphasized, and other good practices will be highlighted to help you rein in your HSM demand.

Request link to watch recording

 

4. Boost the Value You Derive from CICS and Db2 SMF Data

Presenter: Todd Havekost

This session will present the benefits of modernizing how you understand and leverage SMF data for CICS and Db2 Performance analysis.

Instead of being overwhelmed by massive volumes of CICS and Db2 SMF data and combing through countless static reports, discover how interactive analysis using an intuitive GUI interface with context-sensitive drilldowns can elevate your effectiveness to an entirely new level.

Request link to watch recording

 

5. Lessons on Optimizing Processor Cache From z15 Upgrade Case Studies

Presenter: Todd Havekost

Since it is likely that 1/3 to more than half of your total CPU cycles are spent waiting for data to be staged into level 1 processor cache, it is critical to understand and have visibility into this significant component of your CPU consumption.

This is not ivory tower theory… every main point in this presentation is backed up with real-life case studies from more than 70 sites across 8 countries.

And though these concepts have been presented before, the presentation continues to be enhanced with additional before-and-after data from sites quantifying the CPU reductions they have achieved through more effective utilization of processor cache.

Request link to watch recording

 

6. The All-Flash datacenter: How come my I/O Response isn’t twice as fast?

Presenter: John Baker

In IT, the term “Flash” is both ubiquitous and vague. The solid-state drive in your laptop, the new memory in your z15, your new all flash storage array – these all boast flash technology that promises to make everything faster.

Many datacenters have adopted flash technology and are observing that their I/O response times are not dramatically different. Why? John breaks down this relatively old invention to understand what it can – and cannot – do for your datacenter.

Request link to watch recording

 

7. Value and Visibility into zERT Network Encryption Data

Presenter: Todd Havekost

Given the importance of security in today’s world, managing network encryption is a critical requirement for almost every z/OS environment.

I consider the introduction of zERT SMF 119.12 records to be perhaps the greatest advance in SMF data since CPU Measurement Facility (CPUMF) began providing instrumentation of processor cache metrics through SMF 113 records in 2008.

Attend this session to learn more about the value provided by this new zERT data, and to gain the visibility your security team needs to derive great value from this data.

Request link to watch recording

 

8. Why did my job run so long? Understanding and applying z/OS Performance Concepts

Presenter: John Baker

There are few things more annoying than a daily job running dramatically longer for no apparent reason. Such delays can trigger financial penalties leading to pressure on the performance team.

Performance Analysis is about identifying the distribution of response times and dealing with each component. In this presentation, we will explain the meaning of some the most useful components and provide practical recommendations on how to improve application and overall system performance.

Request link to watch recording

 

9. Boost the Value You Derive from MQ SMF Data through a Modern Approach

Presenter: Todd Havekost

IBM’s MQ is very widely used across today’s z/OS environments. But reporting capabilities for MQ SMF data have lagged behind those of other subsystems.

This session will present the benefits of modernizing how you understand and leverage SMF data for MQ performance analysis.

Instead of being overwhelmed by massive volumes of MQ Accounting data with very limited visibility, discover how you can elevate your effectiveness to an entirely new level.

Request link to watch recording

 

10. Getting to Know Your WebSphere for z/OS Workload

Presenter: Dennis Moore

WebSphere Application Server is mission-critical for many businesses today. However, for many mainframe performance/capacity specialists, these workloads can be a bit of a mystery – a black box of resource consumption that is hard to get your arms around.
There are many areas of WebSphere that can leave even a seasoned z/OS performance specialist scratching their head. Knowing what you want to see and where to look is one hurdle to overcome, but even then, how do you access that data? And more importantly, how do you visualize it in a way that makes sense? This webinar will help you:

  • Gain a better understanding of your WebSphere workload through SMF data
  • Quickly see transaction rates, CPU/zIIP utilization and response times
  • Spot trends, patterns and unusual conditions

Join us to learn how you can shine a light into this otherwise black box!

Request link to watch recording

 

11. Life in the Fast Lane: zHyperlink

Presenter: John Baker

The z14 and z15 support a completely new I/O method called zHyperLink. This is easily the most substantial I/O announcement from IBM since the introduction of FICON. We all know that the best I/O is no I/O but every record won’t fit in your buffer pools, so I/O is a fact of life. What about more cache or flash drives? The many options to accelerate your speed on the I/O highway can make you lose your mind – come check out the fast lane!

Request link to watch recording

 

12. Does IBM’s Recent Tailoring of Tailored Fit Pricing Make It a Better Fit for You?

Presenter: Cheryl Watson of Watson & Walker

Every IBM software pricing option has a set of customers that it will benefit. For the remaining customers, one of the other options might make more sense. IBM’s Tailored Fit Pricing option had some aspects that limited the set of customers that it was a good fit for. In this webinar, mainframe maven Cheryl Watson describes recent, unannounced, changes to TFP, and explains how those changes might alter your calculation about whether TFP is right for your company.

Request link to watch recording

 

13. Is a Sub-Capacity CPC the Right Move for You?

Presenter: Frank Kyne of Watson & Walker and Todd Havekost of IntelliMagic

Most installations tend to upgrade their CPCs to the equivalent model in the newer generation – for example, from a z13 710 to a z15 710. Accordingly, IBM’s capacity planning tools are designed to model upgrades to newer generations within the same speed range (7xx to 7xx, 5xx to 5xx, and so on). There are numerous stories of customers moving to a lower speed range (z13 7xx to z15 6xx, for example) and finding that the performance exceeds their expectations. But if the IBM tools are not intended to model such moves, how do you evaluate if such an upgrade would be right for your workloads? In this session, Frank and Todd will discuss the attributes that they use to evaluate such upgrades.

Request link to watch recording

 

14. The Value of Automated z/OS Performance Change Detection

Presenter: Todd Havekost

With all the complexity and workload variability present in today’s z/OS systems, it is important to have significant deviations of key metrics from their historical norms called to your attention. Built-in “change detection” functionality to automatically identify these deviations accompanied by intuitive capabilities to investigate the underlying causes provides another important step forward facilitating effective availability and performance management. This session will show how this capability complements health assessments using built-in instrumentation of z/OS best practices and will show real-life examples of how it can add value across several areas of the z/OS infrastructure, including CPU, CICS, Db2, CF, Disk replication, and batch jobs.

Request link to watch recording

 

15. Tune your TS7700 Cache Capacity

Presenter: Katja Denefleh

You have multiple functions and parameters at your disposal to define which logical volumes will remain in the TS7700 cache, regardless if you use a TS7700 Disk-Only or a TS7700 with Tape attach. This session gives you detailed information about the different options. Learn more about Cache Partitions, Retention Policies, Preference Groups, Autoremoval, and parameters like COPYFSC and RECLPG0.
We will discuss how these parameters control the cache content and how they may influence recovery times. After this webinar you will be able to optimize the cache usage.

Request link to watch recording

 

16. Your Datacenter Under TFP: The New Rules of Measurement

Presenters: Cheryl Watson of Watson & Walker and John Baker of IntelliMagic

Tailored Fit Pricing is no longer an abstract concept as many data centers have adopted this new pricing model. For those that held back, recent enhancements from IBM have made TFP potentially more attractive. While TFP has the potential to greatly simplify software costs the Capacity Planner/Performance Analysts (CP/PA) needs to adjust many of their tried and true methods for tracking – and controlling – MSU consumption. Are you paying too much? Have your measuring tools and techniques adapted to these new rules? Join Cheryl Watson and John Baker as they dive into this critical subject. They’ve been known to have an opinion or two.

Request link to watch recording

 

17. Preparing for and Managing Peak Periods in 2020 and beyond

Presenters: Brent Phillips and Jerry Street

2020 will undoubtedly go down as a year to remember for each and every one of us. The way that every business has adapted to the changes shows resiliency and creative professionalism in positive ways. One thing that has not changed is the need to ensure that our infrastructure and applications can handle peak loads at any time. This webinar will demonstrate how to quantify risk in the z/OS infrastructure to ensure better availability in peak periods, and how intelligent navigation through the RMF/SMF data can accelerate problem resolution times and display newly supported SMF data.

Request link to watch recording

 

18. Transparency in z/OS Infrastructure Performance Analysis – The Benefits of Collaborative and Explainable Analytics

Presenters: Dan Speer and Todd Havekost

Analyzing and optimizing performance and cost across the different z/OS infrastructure areas has led to many “silos” of expert knowledge which often create natural barriers to collaborative and quick problem-solving. It also makes it difficult for managers and LOB executives to easily understand the performance health and cost optimization status for their applications. This webinar will discuss the historical reasons why these silo barriers exist, their ramifications, how to achieve greater transparency and collaboration, and a roadmap to help break down the silos one application at a time.

Request link to watch recording

 

19. How long is the line? Practical Applications of Queueing Theory for The Rest of Us

Presenter: John Baker

Your mainframe has the capacity to service many requests concurrently. However, as with any system, there are limits. As utilization increases, queues will inevitably develop. This session will look at the applications that are impacted, and whether you need more hardware or can optimize with tuning.

You don’t need to be a mathematician or programmer to answer these “queueing theory” questions. Join this session and learn how IntelliMagic Vision can provide clear answers to these and other questions in your z/OS environment. With direct visibility into delays and the reasons for them, as well as predictive analysis, who needs theory?

Request link to watch recording

 

20. z/OS Infrastructure Operations: Biggest Challenges and Trends for 2021 – Part 1

Presenters: John Baker, Todd Havekost and Brent Phillips

Last year, over the course of 19 zAcademy educational sessions, we learned of some of the most pressing issues affecting data centers, ranging from CPU Consumption and new pricing models to performance issues in Db2, CICS, and systems components, to configuration best practices for an optimal environment.

Learn best practices for configuring your environment for optimal performance, selecting the best pricing model for your site, and how to navigate performance issues in your Db2, Systems, CICS, and other z/OS components simply by accessing the RMF and SMF data available to you.

Request link to watch recording

 

21. z/OS Infrastructure Operations: Biggest Challenges and Trends for 2021 – Part 2

Presenters: John Baker, Todd Havekost and Brent Phillips

Our panel of experts continues the discussion from February 9th, addressing 2020’s biggest challenges to infrastructure operations. They draw on real-world experiences at many mainframe sites around the world, and where appropriate illustrate their responses with demonstrations using intelligent and automated analysis of RMF and SMF

Topics to be covered in Part 2 of this session will be based on input from registrants, along with overflow topics from the first session, including:

  • Measuring the effects of changes: Compilers, CPU, Memory
  • Deriving value from Db2, CICS, and MQ data

Request link to watch recording

 

22. How to Make the Best of IBM’s TS7700 Virtual Tape Solution

Presenter: Katja Denefleh

Understanding your TS7700 environment is crucial to ensuring you get the most optimal performance out of it. As a follow-up to last year’s zAcademy virtual session on Cache Capacity, this Virtual Tape webinar focuses on Cache Bandwidth.y

Learn more about cache flows, delay premigration, the new premigration behavior introduced with TS7700 Microcode 8.5.1.25 (available for TS7760 and TS7770), and the influence of some features like compression or copy policies to your cache bandwidth consumption. To provide the full picture, library backend performance and physical tape drive usage are also discussed.

Request link to watch recording

 

23. Is Your Mainframe Being Maintained like a Ford F-150 Lightning or a Model T?

Presenters: Jerry Street and Jack Opgenorth

Contrary to the misguided public view, modern mainframes are nowhere near antiques, boasting the best performance, encryption, compression, reliability, and instrumentation modern processors have ever experienced.

This webinar will cover in detail the modern-day equivalents of yester-year’s antique performance tools. We’ll also cover:

  • How to save money by identifying wasteful patterns
  • How to save time by using advanced analytics and metric integration
  • How to quickly determine what’s important to review in any environment

Don’t be surprised if we show you something in your toolbox that can be improved!

Request link to watch recording

 

24. Imagine how much you can learn from the Db2 Statistics Data

Presenters: Todd Havekost and Brent Phillips

Db2 produces extensive SMF metrics that can provide great insights into how the many facets of your Db2 environment are operating.

This webinar will include how to:

  • Leverage automated assessments of key metrics to proactively direct your attention to potential risks to availability and performance
  • Explore the extensive buffer pool metrics provided by Db2 and leverage them to inform buffer pool tuning activities
  • Better manage your operation through intuitive visibility into the many other types of metrics provided in the Statistics data
  • Derive important Db2 operational insights from integration with other types of data

Request link to watch recording

 

25. Imagine How Much You Can Learn Exploring Db2 Accounting Data

Presenter: Todd Havekost

In this session on gaining insights from the Db2 SMF data series, we take a deep dive into the Db2 Accounting (SMF 101) data.

Our learning journey will include:

  • Examining the differing profiles of work generated by the various callers of Db2 services (“connection type”), including CPU and SQL activity, suspend events, and elapsed time profiles
  • Exploring the visibility provided by “correlation ID” into the specific drivers of Db2 activity (e.g., by CICS transaction, batch job, etc.)
  • How focusing analysis of DDF work by “authorization ID” can help manage a challenging workload
  • Introducing important Db2 operational insights from integration with other data types, including CICS transaction (SMF 110.1) data

Request link to watch recording

 

26. User Experience Leveraging Db2 SMF Data to Solve Business Problems

Presenters: Walter Auerochs (DATEV), Hendrik Klimek (DATEV), and Todd Havekost

In this session, the third in our Db2 webinar series, two users at one of our customers share how they have leveraged IntelliMagic Vision to help manage their environment more effectively and enhance Db2 availability and performance.

They will present several examples of how dynamic navigation through their SMF data has helped them quickly identify and solve business problems. Their story also shows how a common, intuitive interface providing visibility into data types across the platform is enhancing collaboration among their infrastructure teams.

Request link to watch recording

 

27. Imagine How Much You Can Learn Exploring CICS Transaction and Statistics Data

Presenters: Todd Havekost

CICS is the leading z/OS transaction manager. Watch this session and find out how much you can learn through exploring CICS Transaction (SMF 110.1) and CICS Statistics (110.2) data.

Our learning journey will include:

  • Leveraging automated assessments of key metrics to proactively direct your attention to potential risks to CICS region availability and performance
  • Logical grouping of the approximately 100 timing buckets provided for CICS transactions to facilitate response time analysis
  • An introduction into the many other types of metrics available at the transaction level from the more than 270 non-timing related fields in the 110.1 records
  • Visibility into levels of detail within CICS regions provided by the Statistics data including by storage area, TCB pool and mode, TCLASS, and file and enqueue names

Request link to watch recording

 

28. Imagine How Much You Can Learn Exploring MQ Statistics and Accounting Data

Presenters: Todd Havekost

MQ Statistics and Accounting SMF data provides extremely useful insights into MQ management and operation. Unfortunately, extracting those insights from the SMF 115 and SMF 116 record types is challenging – and raw data pulls lack context or accessibility.

With proper access to the insights derived from this data, analysts can optimize their z/OS MQ configurations and activity more effectively and efficiently and have better visibility and control over their environment. This webinar demonstrates how to overcome these common challenges and offers a guide to analysts responsible for and working with MQ environments.

Request link to watch recording

 

29. CPU Reporting and Tuning in a TFP Environment

Presenters: Todd Havekost

IBM’s introduction and active promotion of the Software Consumption (SC) solution within Tailored Fit Pricing (TFP) brings with it a fundamental change in how sites will approach managing and reducing software expense.

Instead of being driven only by CPU usage during the monthly peak four-hour interval, under the SC model, software is charged based on the total CPU consumption for the entire month (at a much lower unit price). This new SC model brings with it a new set of challenges for managing an environment and at the same time potentially significant opportunities to reduce software expense over the long term.

Request link to watch recording

 

30. How Long is Too Long? Multi-period Service Classes

Presenter: John Baker

Duration. Seems simple enough: how long do I give a transaction to get done? The reality is somewhat more complex. Firstly, the duration is not wall-clock time, it’s weighted Service Units. And what are your ‘weights’ (coefficients) anyway?

Multiple periods are one of the most powerful – and dangerous – tools in the performance analyst’s arsenal. They can ensure critical work gets done and runaway work can’t take over. This webinar provides a timely update to setting up or reviewing this critical area.

Request link to watch recording

 

31. Just say no: A case for eliminating I/O Priority management

Presenter: John Baker

As of z/OS 2.5, WLM coefficient settings were removed; IBM made a good move in sunsetting an obsolete set of variables. I/O priority should follow. WLM I/O Priority has been around for a long time and is in use at many data centers. A recent survey revealed many sites are not even clear on what the setting does. While the default is ‘off’ the recommendation in the WLM Planning manual is ‘on’. In this presentation, we will demonstrate why this option should be turned off and perhaps removed entirely like the coefficients.

Request link to watch recording

 

32. Diving into the Mysteries of the Pyramid’s Pools

Presenters: Jerry Street and Sally Mir

DB2 Buffer Pool performance is essential for applications in a z/OS environment. Buffer pools in data sharing configurations have corresponding coupling facility structures, so monitoring them from a coupling facility perspective as well as a DB2 perspective is key.

This zAcademy session covers the basics of coupling facility performance and dives into DB2 performance, specifically DB2 group buffer pool performance.

Request link to watch recording

 

33. Insights You Can Gain from Integrated Visibility Across Types of SMF Data

Presenters: Todd Havekost

SMF data has the potential to provide great insights into the operation of components across the z/OS platform, but infrastructure teams face many challenges seeking to maximize the value they derive from that data so that they can deliver high levels of availability and performance.

This webinar will explore how SMF data analysis becomes far more effective when a common, intuitive interface provides integrated visibility into the many types of SMF data produced by components across the z/OS platform.

Request link to watch recording

 

34. zHyperLink Read Performance & Lessons Learned

Presenters: Joe Hyde

The zHyperLink Express feature was announced by IBM in September 2017, providing up to 10x better response times in read cache hits. The roll out to production has been slower than most new interface technologies on the mainframe given that it’s an adjunct and not a replacement to FICON.

Join Joe Hyde as he shares some recent DB2 production data which highlights the speed of zHyperLink read I/Os.

Request link to watch recording

 

35. Leveraging zERT and Other SMF Data to Manage and Optimize Network Encryption

Presenters: Jack Opgenorth and Todd Havekost

Given the importance of security in today’s world, managing network encryption is a critical requirement for almost every z/OS environment. zERT data can be of great benefit to network security teams who are responsible to ensure that transmitted data is encrypted in accordance with corporate standards.

Join this session to learn more about the value provided by zERT and other SMF data.

Request link to watch recording

 

36. Mainframe Health Checks 101 – When was your last checkup?

Presenters: Dan Speer and John Baker

Comprehensive health checks for your z/OS mainframe are different than day-to-day performance analysis and management and are essential for heading off budding availability risks before they grow out of hand.

We’ll cover real-life case studies that assisted clients in avoiding potential performance or availability issues and examples of cost savings opportunities identified during a mainframe health check. Even analysts with the finest tuned mainframes will walk away with some new ideas.

Request link to watch recording