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

Document ID:  TEC1606315
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Plan Analyzer for DB2 for z/OS

Releases

  • CA Plan Analyzer for DB2 for z/OS:Release:19.0

Components

  • Statistics Manager:PSM
Introduction:

Statistics Manager

Excluding tablespaces from the Strategy

Question:

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

strategy?

Environment:
z/os DB2
Answer:

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. 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >