search cancel

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

book

Article ID: 15349

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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.