Understanding Db2 Statistics and Their Usage

Project and Program: Information Management, Database

Tags: Proceedings , 2020 , SHARE Fort Worth 2020

Db2 for z/OS gathers and uses metadata, or data statistics, to help manage the system and applications.  This presentation will give an overview of the stats used by the optimizer to determine access paths, and it will also cover the space stats used to help schedule running the REORG, COPY, and RUNSTATS utilities.  Recommended best practices like using PROFILEs, and new features in V12 will also be included.-Craig Friske-Rocket Software

Back to Proceedings File Library