June 22, 2023

Sponsored By: 
Monitor, Scalability andAvailability
Opening Remarks
Use profiles to monitor and control Db2 application context - Maryela Weirauch IBM
Scalability Enhancements in Db2 13 for z/OS - Mark Rader IBM
Virtual Lunch
Db2 for z/OS availability, efficiency and application stability - Frances Villafuerte IBM
Meeting Wrapup
Abstracts and Biographies: 



  • Presentation title: Use profiles to monitor and control Db2 application context   Maryela Weihrauch  IBM

  • Presentation abstract: With increased popularity of distributed applications, related Db2 system and application definitions were defined in distributed application servers. Sub-optimal definitions could impact on overall Db2 health. Db2 z/OS provides capabilities to create profiles to monitor and control various aspects of a Db2 specific system and application contexts in Db2 profile tables. Db2 13 extends the profile tables to new attributes for local and remote applications. Maryela will review existing profile capabilities and introduce Db2 13 extensions as well as discuss use case examples.


  • Presentation title: Scalability Enhancements in Db2 13 for z/OS  Mark Rader IBM

  • Presentation abstract: Db2 for z/OS can scale horizontally with Parallel Sysplex and data sharing. Db2 13 increases the ability for Db2 workloads to scale vertically.  This session will describe the major scalability features, including changes to virtual and real storage management and DBAT termination.


  • Presentation title: Db2 for z/OS availability, efficiency and application stability enhancements  Frances Villafuerte  IBM

  • Presentation abstract: Db2 13 reduces application outages to accommodate application workload growth and simplify processes for DBAs. This session gives you an overview of following key features:   
    • Db2 13 ZPARM simplification and the thinking behind them.     
    • Explore PBG cross partition search and its impact on applications       
    • The ability to manage application Timeout and Deadlock control through special registers and global variables
    • DDL table space alteration changes to increase application and data availability.


Maryela Weihrauch

  • Speaker bio: Maryela Weihrauch is an IBM Distinguished Engineer, world-wide Data and AI for IBM Z Technical Sales and Customer Success Leader. She has extensive experience with Db2 in terms of systems, application and database design. Maryela is very engaged with enterprises world-wide driving the adoption of new analytics technologies. Her most recent roles in Db2 for z/OS Development have involved determine Db2 for z/OS strategy for HTAP (Hybrid Transaction and Analytics Processing) including the Db2 Analytics Accelerator strategy and implementation as well as Db2's application enablement strategy. Maryela is a member of the IBM Academy of Technology and frequently shares her experience at conferences.

Mark Rader 

  • Speaker Bio: Mark Rader is a Db2 for z/OS specialist in the IBM Z Washington Systems Center.  He has 40 years of technical experience with IBM, and over 34 years with Db2 for z/OS.  He has led many Db2 data sharing implementations and has presented a variety of topics at conferences, including IDUG,  SHARE, IBM Technical University and at regional Db2 user group meetings. He has worked closely with Db2 development in delivering the Early Support Programs for Db2 10, Db2 11, and Db2 12.  He is an author of Redbooks on Parallel Sysplex application considerations, Db2 data sharing, Db2 for z/OS distributed function, and Db2 13 for z/OS and More.

Frances Villafuerte 

  • Speaker bio: Frances Villafuerte is a key senior engineer and technical leader on the Db2 for z/OS Development team. She joined Db2 for z/OS development in 2000 and has been responsible for several critical core functional areas within the product such as online schema change, space data management, insert performance improvement, LOBs and real-time statistics. Frances has wide technical knowledges and experience working with customers, and is also a frequent speaker at various technical conferences.