Exclusion of tablespaces and related indexes from statistics strategies in Statistics Manager

book

Article ID: 15349

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Statistics Manager

Excluding tablespaces from the Strategy



Is there a way to exclude tablespaces from within a Statistics Manager

strategy?

Environment

z/os DB2

Resolution

Currently Statistics Manager does not support the ability to exclude objects as a standard part of it's process via an Exclude option. 

However, an alternate approach could be done using MASKS to achieve the same objective of temporarily excluding certain objects.