We are looking for additional co-sponsors for the Virtual Db2 user group.
The user group has been in existence since 2022 and is gaining respect among users of Db2. The user group gives its sponsors an opportunity to show that they are working with, and helping to build, the Db2 user community.
The user group will meet six times a year with a presentation filling most of the meeting. In the other months, members receive a newsletter. And there is a Facebook page, a Twitter feed, and a LinkedIn group keeping members up-to-date with information about new products or product updates, and articles about Db2.
Welcome to the Virtual Db2* User Group
The Virtual Db2 user group is an independently-operated vendor-neutral site run by and for the mainframe Db2 user community.
*This is a mainframe Db2® information website, not in any way related to, sponsored, or approved by IBM, which is the legitimate owner of the trademark, and any use of the mark in the URL or the body of the site is for information, education, and opinion expression purposes.
The Virtual Db2 user group was established as a way for individuals using IBM's Db2 for z/OS database to exchange information, learn new techniques, and advance their skills with the product.
This Web site provides a central point for coordinating periodic meetings (which contain technically-oriented topics presented in a webinar format), and provides articles, discussions, links, and other resources of interest to IBM Db2 practitioners. Anyone with an interest in Db2 for z/OS is welcome to join the Virtual Db2 user group and share in the knowledge exchange.
Next Virtual Meeting
November 21, 2023 | 10:30am CDT
Gaining Insights from Db2 Statistics and Accounting Data
Db2 produces extensive SMF metrics that can provide great insights into how the many facets of your Db2 environment are operating. This session will explore many examples of how Db2 Statistics (SMF 100) and Accounting (SMF 101) data can be leveraged to enhance performance and availability, including:
Leveraging automated assessments of key metrics to proactively direct your attention to potential risks to availability and performance
Exploring the extensive buffer pool metrics provided by Db2, and leveraging them to inform buffer pool tuning activities
Overview of the many types of other metrics provided in the Statistics data
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 what is often a challenging workload
Drilling into metrics at the plan (and package) levels to navigate through the typically massive volumes of accounting data and quickly focus analysis on the desired subset of data
Introducing important Db2 operational insights that can be derived from integration with other SMF data types, including CICS transaction (SMF 110.1) data
Todd Havekost
Senior z/OS Performance Consultant IntelliMagic
Future Virtual Meetings
January 16, 2024
TBA
Dave Beulke Db2 Consultant
March 19, 2024
TBA
—
Virtual Db2 User Group
Sponsored by:
The Virtual Db2 user group is free to its members.
We are pleased that IntelliMagic and Planet Mainframe are able to help us maintain the independence and existence of this group.
Sponsorship opportunity
We are looking for additional co-sponsors for the Virtual Db2 user group.
The user group has been in existence since 2022 and is gaining respect among users of Db2. The user group gives its sponsors an opportunity to show that they are working with, and helping to build, the Db2 user community.
The user group will meet six times a year with a presentation filling most of the meeting. In the other months, members receive a newsletter. And there is a Facebook page, a Twitter feed, and a LinkedIn group keeping members up-to-date with information about new products or product updates, and articles about Db2.