ZMISC-08 || All about Db2 for z/OS Packages

Mark Rader, Tori Felt, Anna McKee – IBM WSC

Abstract

Abstract: Db2 for z/OS packages – the compiled and executable form of static SQL, and the structural enablers of dynamic SQL – have been around for a LONG time. That said, effective management of packages has become more important in recent years, thanks to things like newer bind options (e.g., APPLCOMPAT, CONCENTRATESTMT), newer availability and concurrency enhancements (e.g., rebind phase-in, autobind phase-in) and newer mechanisms for controlling and enabling package behavior (especially the Db2 profile tables). Learn about all this, and more, in this session.

Speaker Bios

Mark Rader

Mark Rader is a Db2 for z/OS specialist in the IBM Z Washington Systems Center. Mark has applied his Db2 for z/OS experience with clients across a wide variety of projects. He is a frequent speaker at conferences and regional Db2 for z/OS user group meetings. He works closely with Db2 for z/OS development in rolling out new Db2 versions to clients. 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.

Tori Felt

Tori Felt is a Db2 for z/OS Specialist in the IBM Z Washington Systems Center. As part of the Db2 for z/OS team, Tori analyzes client data, makes technical recommendations, and delivers presentations at conferences and Db2 user groups. She delivers the Db2 for z/OS REST and Hybrid Cloud workshop and participates in the delivery of the Db2 13 for z/OS workshop.

Anna McKee

Anna McKee is a Technical Enablement Specialist in the IBM Z ISV Center, where she manages and supports all Db2 for z/OS subsystems. She works with hundreds of independent software vendors to deliver the latest SMPE maintenance, perform Db2 installations and configurations, enable Db2 data sharing, support z/OS migrations, and provide expert consultation. Additionally, Anna contributes to the Washington Systems Center Db2 team by delivering Db2 13 Technology Workshops and assisting with IBM Z Health Checks, helping clients optimize availability and performance in their z/OS
environments.