With the current interest in DevOps, a renewed focus on streamlining database change and integrating it with associated application change has been evident in recent times.In this paper we will look at one part of the overall topic of agile database development – the concept of database refactoring.
Over the course of the past several releases of DB2 for z/OS, IBM has added many features and capabilities that are transforming the platform. This presentation takes a look at the big changes that have been introduced to DB2 including new SQL, universal table spaces, improved security, and more. Th
It has always been very important to understand when any changes in your database's configuration are made – some changes can have huge consequences. This article presents a methodology for monitoring your databases' configuration and detecting when changes have been made.
Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them,