Modern Db2 for z/OS Physical Database Design

Project and Program: Information Management, Database

Tags: Proceedings , SHARE Virtual Experience 2021

Suppose a Db2 for z/OS DBA from 10 years ago were suddenly transported to our time, and looked over the physical design of your Db2 database. Would he see anything that he did not recognize? In many cases, he would not. In this session, I will cover Db2 enhancements in the area of physical database design that have been introduced over the past decade. You'll learn about relative page numbering, partition-by-range versus partition by growth, tightening up your indexes, leveraging transparent archiving, using row permissions and column masks instead of security views, and more. Get modern with your Db2 physical database design!

Back to Proceedings File Library