Statistics event monitors are an extremely useful way to get periodic monitoring of basic metrics on your system. They're just well-disguised behind a somewhat misleading name.
OVERHEAD and TRANSFERRATE are tablespace parameters that the optimizer uses to help choose an access plan. Are the defaults good enough? (hint: probably not) In this blog post, I describe a simple way to measure values for your system.
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.
As guest blogger, Russ Stocker shares useful tips on DB2 Large Object (LOB) performance. Part 2: a primer on LOB storage management